calculated measures in values and columns

[Anonymous]

Hi all, 

I wish to end up with a matrix like this: 

Measures in bold have been calculated from my data set as calculated measures. even the header called "actual. budget and Past year". I have managed to place the ratios on the rows under the "value" box but icannot put the calculated measures of "vs budget and Vs past year" in the column. Is there a way to do this? 

Thanks so much for your help! 

Evie

[v-xicai]

Hi @Anonymous ,

You can put the ratios onto the Rows, and put the actual, budget and Past year onto Values.

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

The ratios are calculated measures and cannot seem to be placed in the rows.