Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Please take a look at the QVW attached. I believe my requests are straightforward, but I can't get them to work.
This?
1st table expression:
Avg(Aggr(Sum(Data), Company, Channel, Customer, ProductCategory, Year))
2nd table expression:
sum(Data)/Sum(TOTAL <Company>Data)
This?
1st table expression:
Avg(Aggr(Sum(Data), Company, Channel, Customer, ProductCategory, Year))
2nd table expression:
sum(Data)/Sum(TOTAL <Company>Data)
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?