Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How to show multiple line items for same row in matrix visual

Hi,   I am looking for a matrix like visual which could show multiple rows for one type of line item. Eg:   Rows Col1 Col2 TS A 1 2 Wk1 A 3 4 Wk2 B 11 12 Wk1 C 21 22...
  • MFelix's avatar
    MFelix
    6 years ago

    Hi Anonymous ,

     

    Being your values calculated as measures you don't have the option don't summarize, what you can do to work around that can be create a new column with the [Rows] and [TS] values togethers then use that as your first value on the rows, drill down to the latest level, turn off word wrap and hide that column check the image below:

     

     

    It's a poor workaround but can be an option, based no the low level of information are showing.

     

    Regards,

    MFelix