Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I would like to have a pivot table like this:
Product A | Product B | Product C | SubTotal | SubTotal | ||||||||||
IN | OUT | IN | OUT | IN | OUT | Product A | Product B + C | |||||||
PT | ES | Others | PT | ES | Others | PT | ES | Others |
|
| ||||
Jan | 8 | 2 | 1 | 4 | 4 | 2 | 1 | 1 | 4 | 2 | 1 | 1 | 15 | 16 |
Feb | 7 | 4 | 3 | 5 | 1 | 2 | 2 | 1 | 2 | 2 | 19 | 10 | ||
Mar | 9 | 2 | 2 | 2 | 2 | 1 | 1 | 1 | 2 | 1 | 1 | 1 | 13 | 10 |
SubTotal 1 |
| 8 | 6 | 11 |
| 5 | 4 | 2 |
| 5 | 4 | 2 |
|
|
SubTotal 2 | 24 | 25 | 7 | 11 | 7 | 11 |
|
| ||||||
Total | 49 | 18 | 18 | 49 | 36 |
The dimensions are "Month", "Products", "IN/OUT" and "Countries" and the respective quantities are given by a sum expression.
For now I've managed to do the majority of the table but i'm lacking the experience to do lines and columns in red.
How can I do the SubTotals columns and lines that I've mencioned above?
Thanks in advance
Presentation sheet of charts properties, select the dimension in the top left and tick the Show Partial sums checkbox below it. Looks like you'd need to do this for the "IN/OUT" and "Countries" dimensions.
Jonathan
Thanks jonbroughavone.
I've tried to do that but it creates the total line by line and not column by column which means I end up getting:
Product A | Product B | |||||||||||
IN | OUT | Total | IN | OUT | Total | |||||||
PT | ES | Others | Total |
| PT | ES | Others | Total | ||||
Jan | 8 | 2 | 1 | 4 | 7 | 15 | 4 | 2 | 1 | 1 | 4 | 8 |
Feb | 7 | 4 | 3 | 5 | 12 | 19 | 1 | 2 | 2 | 4 | 5 | |
Mar | 9 | 2 | 2 | 2 | 6 | 15 | 2 | 1 | 1 | 1 | 3 | 5 |
Total | 24 | 8 | 6 | 11 | 25 | 49 | 7 | 5 | 4 | 2 | 11 | 19 |
Which is not what I actually want. Is there any flag or option that I have to enable to do what I pretend?
Not that I know of.
Jonathan