10 Replies Latest reply: Mar 15, 2012 10:59 AM by Marc Wintjen

# Issue with Totaling a Percentage in Pivot Table

Hi,  I have an issue with trying to total a percentage.  I've attached an example and I'm trying to show the Sum of 2 Percentage values in a Pivot table.  Is it possible to total the values and not display the Dimension that makes up that total (see attached)?  If a straight table is a better solution, I'm fine with that as well.  Thanks!

• ###### Issue with Totaling a Percentage in Pivot Table

Since I am using a PE version so I can not open your report, but I can give you a suggestion.

Try to use "straight table", select "properties"-->"presentation"-->select the dimension you want to hidden-->select the radio box "hide column".

• ###### Re: Issue with Totaling a Percentage in Pivot Table

Please see the attached QVW and let me know if this is what you are looking for.

Thanks,

Dan

• ###### Issue with Totaling a Percentage in Pivot Table

Hi, in your ex. in the second table, you'd like to hide those  Products groups which areNULL but still see the sum of the 5 for the NULLS + Company Product Group 1? (in your ex. would be 102.78%)

• ###### Re: Issue with Totaling a Percentage in Pivot Table

Hi,

Hope it helps you.

Regards,

Jagan.

• ###### Issue with Totaling a Percentage in Pivot Table

Not really sure if I got your issue correctly, if you want to show the total line value in all lines for that group, you could try something like

=sum(total<Quarter> [Weighted Avg Calc])

as expression, i.e. using the total qualifier with appropriate field list.

• ###### Issue with Totaling a Percentage in Pivot Table

Adding a Total within the Sum did give me the right answer but when I hide the Null Company Product Groups, it gives me the wrong total (shows 51.65% vs. 102.78%).

• ###### Issue with Totaling a Percentage in Pivot Table

Guys,  thanks for your quick response - Moving the Dimensions will not resolve this because I need to only show the Company Products Group 1 or show null values for Products that don't have a Company Product Group.   So the final result would look like this:

 Customer   Group Market Basket Year Quarter Company   Products Group Calc Customer 1 Market Basket 1 2010 2010 - Q2 CompanyProduct Group   1 102.78% Customer 1 Market Basket 1 2010 2010 - Q2 CompanyProduct Group   1 104.86%
• ###### Re: Issue with Totaling a Percentage in Pivot Table

Hi,

Use this expression.

Sum(Aggr(sum([Weighted Avg Calc]),[Customer Group],[Market Basket],Year, Quarter))

Check the attachment.

Regards,

Jagan.

• ###### Re: Issue with Totaling a Percentage in Pivot Table

I assume your Quarters should differ, so maybe like attached?

• ###### Issue with Totaling a Percentage in Pivot Table

Awesome - Thanks!