
Calculate percentage values in pivot table
Simon Koenen Nov 2, 2011 8:11 AM (in response to Simon Koenen)OK I found the solution
The formular must be:
SUM([Values]) / SUM(Total <[Month]> [Values])
It is also possible to do a set analysis with this:
SUM({<[Country]={'DE'}>}[Values]) / SUM({<[Country]={'DE'}>}TOTAL <[Month]> [Values])
This will limit the country field to Germany and will make a total over all dimension in chart except the month.

Re: Calculate percentage values in pivot table
Sajeevan Govindan Nov 2, 2011 8:15 AM (in response to Simon Koenen)Hi Simon,
Please use the below for your 2nd expression
Sum(Values) / aggr(NODISTINCT sum(Values),Month)
Regards,
Sajeevan

Calculate percentage values in pivot table
Lav Jain Mar 16, 2012 6:46 AM (in response to Sajeevan Govindan )Hi,
i think you can solve my problem again.
i've dimemsions dim1,dim2,dim 3..in hierarchial format as in pivot table.
i've a value column in the table, as one expr....i'm showing sum(value) and i also have dimension due date....& if the due date <today() date then in the expr column Overdue Amt i simply show sum(value) else i'll show it the Not due column...this is fine....
now i've to find %Overdue & %Not due.....wich is Overdue Amt/sum(value) & Not Due Amt/sum(value) respectively...
i'm getting the % fine..for each row...but at the total level i dnt want to see sum of all % for Overdue & %Not Due
Bt only the sum of Overdue Amt/sum of Remainin Amt & same for %Not due as well
Plz help
stuck for 1 day cmplete
Regards


Calculate percentage values in pivot table
Sajeevan Govindan Mar 18, 2012 3:14 AM (in response to Simon Koenen)Can you attach sample QV file?