Reordering the Columns in Matrix

[encamped1]

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?

[amitchandak]

@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