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

weighted averages on pivot table

Hi

Need help,

I have the weighted average calculated in a straight table Totals area for a customer

I need to display this total per customer  in a pivot table

or

if there is a way to sum of rows in a pivot table that would help too.

2 Replies
Not applicable
Author

Create a Expression and use Aggr, here's an example you could use it:

Aggr(SUM(Totals), Customer)

ramoncova06
Specialist III
Specialist III

you can do this by using total and then use then group them by customer field

sum(total <Customer>Totals)