Forum Discussion

volekss's avatar
volekss
Frequent Visitor
8 years ago
Solved

Group rows without measure

How can I group rows in table or other visual if they doesn't contain measure and I can't use agregation? I would like to transform following data table to following report:
  • v-huizhn-msft's avatar
    8 years ago

    Hi volekss,

    I reproduce your scenario and get expected result.

    1. Create sample table as follows.



    2. Create a matrix, turn off the "Stepped layout" button, select all fields as rows level, expand the matrix, you will get expected result.

         

    Best Regards,
    Angelia