Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
i've created in VISUALIZATION the tab 1 where columns c) and d) are obtained with formulas. Now, i would create the table 2 but when i create it by converting the table one into a pivot or by creating a new table with a dimension a) and measure d) the result assigned to A,B, C is always zero. I don't understand why.
It could be grateful if you could help me. thanks a lot
1) | a) | b) | c) | d) |
Category | Month | Values | tot for category | |
A | Jan | 0 | 2 | |
A | Feb | 2 | 2 | |
A | March | 0 | 2 | |
B | Jan | 1 | 7 | |
B | Feb | 1 | 7 | |
B | March | 5 | 7 | |
C | Jan | 0 | 5 | |
C | Feb | 0 | 5 | |
C | March | 5 | 5 | |
2) | Category | Values | ||
A | 2 | |||
B | 7 | |||
C | 5 |
It's because in a pivot table the dimensions contract. If you want to see it the same way you do with table 1, you have to expand it clicking the +. At the end of the day c) is a count and d) a sum of c).
It's because in a pivot table the dimensions contract. If you want to see it the same way you do with table 1, you have to expand it clicking the +. At the end of the day c) is a count and d) a sum of c).