Hi All,
I have created a pivot table with few dimensions having QtrYear & Year part of it. Below is how i am getting now (CurrentTable) but expect is the second one. Please suggest how this can be achieved
CurrentTable:
| | Year | 2020 | 2021 | |
| GL_Category_Description | QuarterYear | 2020-Q3 | 2020-Q4 | Total | 2021-Q3 | Total | Total |
| Assets | | $100.00 | $250.00 | $350.00 | $100.00 | $100.00 | $450.00 |
| Equity | | $100.00 | $300.00 | $400.00 | $100.00 | $100.00 | $500.00 |
ExpectedTable:
| GL_Category_Description | QuarterYear | 2020-Q3 | 2020-Q4 | Total 2020 | 2021-Q3 | Total 2021 | Total |
| Assets | | $100.00 | $250.00 | $350.00 | $100.00 | $100.00 | $450.00 |
| Equity | | $100.00 | $300.00 | $400.00 | $100.00 | $100.00 | $500.00 |
Thanks,
