How to place one measure above another w.r.t dimension in table chart

Hi team,

I have two dimensions Year and Quarter Number with two measures This year sales and Last year sales.

TY= This Year(2022)

LY = Last Year(2021)

a5807bc1-c0b9-4a35-8fa9-17ade3a51dc8.png

I want to place the measures data as and calculate chage% :

95519588-0964-494b-a105-5ef8e5a0dbf9.png

or to explain the use case then this is who data should look like

b1369227-d1fb-4621-8d3e-54744b6e4249.png

One measure field which shows both measure data.

Thanks in advance

Rohit

0 1 86
1 REPLY 1

a quick/easy way would be to create row totals and then hide the individual measures from the visualization

Top Labels in this Space
Top Solution Authors