Announcements
cancel
Showing results for
Did you mean:
Luminary

## 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!

1 Solution

Accepted Solutions
MVP

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

10 Replies
Not applicable

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".

Creator II

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

Thanks,

Dan

Luminary Alumni

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%)

MVP

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.

Luminary Alumni

Hi,

Hope it helps you.

Regards,

Jagan.

Luminary
Author

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%
Luminary Alumni

Hi,

Use this expression.

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

Check the attachment.

Regards,

Jagan.

Luminary
Author

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%).

MVP

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

Community Browser