List view with list and metrics in rows

Highlighted
New Contributor

List view with list and metrics in rows

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

1 REPLY 1
Highlighted
Certified Master Anaplanner

Re: List view with list and metrics in rows

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