Help with the Aggr function

[hobanwashburne]

Please take a look at the QVW attached. I believe my requests are straightforward, but I can't get them to work.

[sunny_talwar · Accepted solution]

This?

1st table expression:

Avg(Aggr(Sum(Data), Company, Channel, Customer, ProductCategory, Year))

2nd table expression:

sum(Data)/Sum(TOTAL <Company>Data)

[swuehl]

Your second request can be achieved by using

=Num(sum(Data) / sum(TOTAL<Company> Data),'##.00%')

Not sure about your first table, where do you want to show that average?