Skip to Content
0
Former Member
Aug 29, 2007 at 10:12 PM

Display % of each column below the column

19 Views

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