Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Pivot table avg

Hi,

using a pivot table I have this situation:

CatturaPivot.JPG

so I have total for both columns: I wouldn't have total for the second one but the average of the percentage.

Can I do it? How?

Thank you!

12 Replies
Anonymous
Not applicable
Author

You are right!

Why when I reduce everything it makes total af percentage?

CatturaPivot3.JPG

Is there any way to not do so?

Not applicable
Author

you need to change expression from sum to avg

Anonymous
Not applicable
Author

Wonderful!!

I think I've tried everything but I was not convinced ... I did not grant that there were multiple lines articolo!

Thank you so much, I just learned something new!