Jump to content

Cross table - difference between calculated % share vs Year ago


Jan Jany

Recommended Posts

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...