Break On Aggregate Value

building reports desktopintelligence
1

I created a variable

UV Total Count =Sum(<CCurrent Amount>) ForEach <Acc Number> In Report

Then did the sorting as per new variable based on UV Total Count .

UV Type =If <UV Total Count> < 10000 Then 1 Else If 
                      <UV Total Count> >= 10000 And <UV Total Count> < 25000  Then 2 Else If  
                       <UV Total Count> >= 25000 And <UV Total Count> <= 100000  Then 3 
                        Else 4

I need to

SUM(UV Total Count) by UV Type

.

It does not let me apply break as it’s aggregate value. Tried lot of different ways.

noreports :us: (BOB member since 2011-06-17)

2

Right there you answered it plus Break is applicable on dimension objects and not measures.!!

You can use Rank feature with Top/Bottom option to display the data you want but this also needs a dimension.

BO_Chief :us: (BOB member since 2004-06-06)

3

BO_Chief,

It seems it’s a common issue to lot of people. Any work around for this?

Thanks

noreports :us: (BOB member since 2011-06-17)