Forum Discussion
Calculation Groups - Difference measures
output
link to file :
https://drive.google.com/file/d/1ZGTRZGdnUbNmPqFTGsyRbRJ6rv1aJgMq/view?usp=sharing
let me know if this works for you .
If this answers your question , mark it as the solution ā so can you can help other people in the community find it easily .
sorry but the image is somewhat confusing .( for me maybe ) .
you want to have 2 levels in the columns :
level1 :
growth current period vs previous perd ,
previous period
current period
level2 :
growth %, growth $
sales , profit
sales , profit
?
Hi Daniel29195 ,
Currently its coming out below which is correct, but how would I add two more columns onto the growth but not onto the other two (Current Period & Previous Period).
Growth needs to have 4 columns on the matrix and current period and previous need to have two.
maybe you can do the following :
create a table with the following structure :level 1 level2
growth total sales
growth total margin
growth calculation 3
growth calculation 4
previous period total sales
previous period total margin
current period total sales
current period total margin
then in your calculation you can use one measure with switch statement
Hi Daniel29195 ,
Apologies I'm a little confused. When you say table with levels, do this mean with calculation groups?
Thanks again
Liam
table using enter data manually .
this way you are creating the structure of your table how you want it to be .
and then you play with the measure and switch to change the calculation behavior base on the column you are in .