Group like Expression Results

[#1]

Hi,

I have an expression which returns the project size based upon the total net sales of another dimension:

=If([Current Net Sales]>=3,'Large Project',if([Current Net Sales]>=1,'Medium Project',if([Current Net Sales]>=.3,'Small Project','Std Dealer Pricing')))

The chart then applies this to each line:

How can I have the chart group all like results together? In the above example there would then only be 3 lines (large project, medium project, small project). When I any of the dimensions, all I get is a grand total.

Thanks!

[swuehl · Accepted solution]

Try as calculated dimension:

=Aggr(

If([Current Net Sales]>=3,'Large Project',if([Current Net Sales]>=1,'Medium Project',if([Current Net Sales]>=.3,'Small Project','Std Dealer Pricing'))),

[PA Number])

and as expression something like

=Count(DISTINCT [PA Number])

[#3]

You sir, just made my day. Thanks a bunch!