Hi,
I have a requirement in Query where we have to calculate % of each column and display the calculated % at the bottom of each column.
I tried creating a formula but in this case it creates a separate column (calculates percentage across the column). As of my knowledge we can have only as a separate column and not at the bottom of each column. Is there any way that we can display the results in the following pattern?
Inv # Customer Country Amt Current Day 0-30 Days....
101 aaa US 2000 400 600
102 aaa US 2000 400 200
103 aaa US 2000 400 300
104 aaa US 2000 400 100
-
TOTAL 8000 1600 1200
-
PERCENTAGE 100% 20% 15%
Curr Day/Amt * 100,
0-30 day/Amt * 100
Thanks in advance.
Shivani