Unable to get total in chart table for one column

[markgraham123]

Hi,

I have 3 dimensions Name, Total and used.

In the chart table, im using an expression (Used/total)%

I can get the total as sum of rows for total and used.

But the same logic not working for the expression where i want to fetch the overall %.

Can someone look into the app atatched.

[sunny_talwar]

Use the same logic for the third expression? If you need Avg then select Avg like this:

[Qrishna]

Summing up all the %s seems to be a bad logic. but u can do something like avg,max min of the %s.

see attached.

[Anonymous]

the expression for Total should be :

sum(Total)

the expression for Used should be :

sum(Used)

then in the 3rd column put:

column(2)/column(1)

Then use expression totals for all 3 columns

[sunny_talwar · Accepted solution]

Or may be this:

Where 74.52% = 459761/616973

Expression:

Sum(Aggr(Used, Name))/Sum(Aggr(Total, Name))

[Anonymous]

Sorry, forgot to attach the example

[markgraham123]

Thanq Adrian.

[markgraham123]

Thanq CHaitanya

[markgraham123]

Thanq Sunny.

[sunny_talwar]

No problem, I am glad I was able to help.

Best,

Sunny