List view with list and metrics in rows

aashishsinghvi
aashishsinghvi
in Modeling

Hello experts, is it possible to model a list display that can show list items and metrics repeated in rows. Please see attached picture. In an excel pivot, this would be dimensions and "Values"  in rows.  I tried looking at the complex, sub-list list types, but couldn't figure out a way to model this. Thanks for your help.

 

Tlist_requirement.png

Tagged:

Answers

  • brendan_morriso
    brendan_morriso

    Hi

    Assuming Item and Location are Lists in your Model, when you create your module you can pivot the data so that Location, List and Line Items (your Metrics column) are in the Rows. Then you can put your Date dimension in the columns. This will return a Module similar to the look of your picture. 

     

    Hope that helps

    Brendan

Categories