Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hi, I'm working on a matrix about product prices and their difference with the previous month, so far I managed with no problem to get this matrix:
Month | 1 | 2 | 3 | 4 | |||||||
Customer | Origin | Brand | Product | Price | Diff | Price | Diff | Price | Diff | Price | Diff |
A | A | A | Product1 | 10 | 0% | 10 | 0% | 12 | 20% | 12.6 | 5% |
A | A | Product2 | 5 | 1% | 6 | 20% | 6 | 0% | 9 | 50% |
In this, the month is the column, and the Price and Diff are the values.
The problem is that my boss wants something a little different, but I cannot find a way to do it.
Does anyone have any suggestions?
My boss wants to be like this:
Month | Price | Diff | |||||||||
Customer | Origin | Brand | Product | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 |
A | A | A | Product1 | 10 | 10 | 12 | 12.6 | 0% | 0% | 20% | 5% |
A | A | Product2 | 5 | 6 | 6 | 9 | 1% | 20% | 0% | 50% |
Solved! Go to Solution.
You could also potentially use a calcuation group for the price, diff calcs, then you should be able to put the calculation items where ever you like in the matrix.
You could also potentially use a calcuation group for the price, diff calcs, then you should be able to put the calculation items where ever you like in the matrix.
Thank you, that solved my problem!!
Regards,
This can be done but it will be painful and a lot of work.
User | Count |
---|---|
84 | |
77 | |
76 | |
43 | |
36 |
User | Count |
---|---|
109 | |
56 | |
52 | |
48 | |
43 |