Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to display the pivot table value in cross table. based on the filter it will show the correct data.
Total | Column A | Column B | Column A-Column B / Coulmn A | Column A1 | Column b1 | Column A1-Column B1 / Coulmn A1 |
---|---|---|---|---|---|---|
2019978 | 16672 | 11477 | 31.16% | 2003306 | 1689948 | 15.64% |
This is my pivot table.
Now i need to show result this value as below table
Legent Label | Percentage |
---|---|
Column A-Column B / Coulmn A | 31.16% |
Column A1-Column B1 / Coulmn A1 | 15.64% |
how can i show this?
Kindly help me
i think u can try here,adhoc report concept..it may work.