Including Peer Groups Set Analysis

[zagzebski]

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

[swuehl · Accepted solution]

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.

[zagzebski]

Thanks - worked great.