Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
How can I unmerge dimension cells in pivot table?
Thank you!
My pivot table looks like this:
Account | Line | 1 | 2 | 3 |
1 | 1 | 100 | 100 | 100 |
2 | 200 | 100 | 200 | |
3 | 300 | 200 | 100 | |
2 | 1 | 100 | 100 | 200 |
2 | 500 | 300 | 100 | |
3 | 200 | 100 | 300 |
and I need it to be like:
Account | Line | 1 | 2 | 3 |
1 | 1 | 100 | 100 | 100 |
1 | 2 | 200 | 100 | 200 |
1 | 3 | 300 | 200 | 100 |
2 | 1 | 100 | 100 | 200 |
2 | 2 | 500 | 300 | 100 |
2 | 3 | 200 | 100 | 300 |
Any ideas?
Use straight table with three expressions rather than using the pivot table because I don't think pivot table will allow you to do what you are trying to achieve here
The problem is that I need a horizontal dimension called period (with values: 1,2,3.....) like in the above example, and I don't know how to do this in straight table.