Multiple Dimensions - Calculation

Ashwini Sayani · August 25, 2023 12:10

Hi, what does the formula look like when I have two time dimensions on the columns?

The user dimension below has only 2023, 2022 as members. The second dimension has Week 1, Week 2 etc.

I want to understand % Sales Var from Week 1 2023 vs Week 1 2022.

0

Comments

1 comment

Sort by Date Votes

Ole Dyring October 03, 2023 14:14
Hi Ashwini,

There is no good way to do this.

However, if you swapped the two dimensions on the horizontal axis (Time dimension before Week dimension) you would be able to do this:
- Add calculation, as a new measure, something like this: sum(-1, 0, m1) - sum(0, 0, m1)
- Add a visibility agent (hide value), working on the new measure, with this condition: mod(allcount(d1:0, d1, m1);2) = 1
BR / Ole
0

Please sign in to leave a comment.