Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Customizing Partial sums

Hi Guys,

is there a way to customize partial sums, and make them have the value of the previous dimension?

for example if i have category then subcategory then products in hierarchy. i want a partial sum on subcategory

but i dont want the label to be just "Total" i want it like "Total Subcategory XXX" where "XXX" is the value of the previous dimension that is Subcategory

i found other threads on that and i am not sure i found that they have replied..

please guide me to other threads if my question is a duplicate... thanks.

Its on a pivot table!!!:)

3 Replies
Not applicable
Author

I also want to ask the same question, is there anybody know a way to do so?  Or is it a mission impossible?

Not applicable
Author

Temp.jpg

You can add a partial sum and a label at the presentation tab of the pivot table properties. Pick the dimension you want the partial sum for and set the label.

ljackson
Creator
Creator

Did you ever get to the bottom of this welsa_chy?

I would like to make the partial sum, in a pivot table, a 'count' rather than a 'sum'.  I'm finding it hard to work out how to do it.  Maybe the functionality isn't there

Can anyone shed any light on this?

Thank you