Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Create a Expression and use Aggr, here's an example you could use it:
Aggr(SUM(Totals), Customer)
you can do this by using total and then use then group them by customer field
sum(total <Customer>Totals)