Forum Discussion
Calculation Groups - Difference measures
Hi,
Could somebody please help me whether this is possible?
I need the layout like below to be in a matrix. I've used a calculation group for current and previous period and this works well because they are using the same fields.
My problem is that Growth has some different calculations to the other two, and as this all needs to be on the same matrix I'm struggling to put it together.
Could somebody please advise if this is possibele?
Thanks in advance
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 .
13 Replies
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
