Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

calculated measures in values and columns

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

 

2 Replies

  • v-xicai's avatar
    v-xicai
    Icon for Community Support rankCommunity Support

    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's avatar
      Anonymous
      Not applicable

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