Cross table - difference between calculated % share vs Year ago

[Jan Jany]

Hello, I have a cross table with categories on axis x, year on columns and calculated % of share per category on axis x

 

 

 

Sum([pt final]) / Sum([pt final]) OVER (Parent([Axis.Rows])) as [% share]What I need is calulate difference between year in % points. For example % points difference between 2020 and 2019 in aircare category is -0,75 % points.

Can someone help me out

[Fabian Duerr]

Do you need it in the same cross table visualization or is it okay to have a separate data table

[Jan Jany]

Idealy in the same table. 

 

 

 

 

 

Thanks 

[Fabian Duerr]

I think the easiest way would be to create a new data table with a pivot operation to get the same result as above (but in a true data table not in a cross table visualization). Then you can simply calculate this difference.

 

Not sure how to get it in the same cross table visualization without knowing the data structure. Maybe you can upload some sample data here if further help is needed.