Forum Discussion
encamped1
3 years agoFrequent Visitor
Reordering the Columns in Matrix
Hi,
Currently, in my dataset the Revenue Band is in column section and Current Year, Prior Year and the Delta columns are defined as measures. When I create a matrix view the default view is created as follow. Is there any way that I can change the hiearchy in the column to group by the measures first then break down by the Revenue band as in the second screenshot in below wihtout changing the dataset design?
1 Reply
- amitchandakSuper User
encamped1 , You need a calculation group for that
Refer examples and formats- Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0