Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I tried using the exclude E() function but not working quite right. Just trying to do something as simple show sales by customer AND sales for all other customers (Peer Group Sales) on the same line. Example below:
Customer | Sales | Peer Group Sales |
A | 200 | 1800 |
B | 400 | 1600 |
C | 600 | 1400 |
D | 800 | 1200 |
Zag
Set analysis is evaluated once per chart, not per dimension line.
I think the easiest approach would be
=Sum(TOTAL Sales) - Sum(Sales)
to calculate the peer group sales.
Set analysis is evaluated once per chart, not per dimension line.
I think the easiest approach would be
=Sum(TOTAL Sales) - Sum(Sales)
to calculate the peer group sales.
Thanks - worked great.