Jan Jany Posted October 8, 2020 Share Posted October 8, 2020 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 More sharing options...
Fabian Duerr Posted October 8, 2020 Share Posted October 8, 2020 Do you need it in the same cross table visualization or is it okay to have a separate data table Link to comment Share on other sites More sharing options...
Jan Jany Posted October 8, 2020 Author Share Posted October 8, 2020 Idealy in the same table. Thanks Link to comment Share on other sites More sharing options...
Fabian Duerr Posted October 9, 2020 Share Posted October 9, 2020 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 More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now