Test if Sum of Revenue by Account is more than 10K

[#1]

I create a new dimension in a pivot table. I would like a different behavior depending on whether the sum of revenues over Accounts is more or less than 10K. For now I came up with

If(AGGR(SUM(Revenue),[Account])>10000,'More','Less')

Which seems not to be working...

What is the correct syntax ?

Account is a dimension in the pivot table.

[alexandros17]

Try this:

If(Sum(AGGR(SUM(Revenue),[Account]))>10000,'More','Less')

let me know

[#3]

brings "Error in calculated Dimension"

[alexandros17]

Could you attach the document?

[#5]

If((AGGR(SUM(Revenue),[Account]))>10000,'More','Less')

is working

[#6]

This is working:

=If(AGGR(Sum(Revenue),Account)>10,'More','Less')

Now, I would like to replace [Account] by another calculated dimension in the pivot table. I am replacing Account directly by the expression of this other calculated dimension, which is a long pick(match...)). Result is calculated, but wrongly gives 'Less' everywhere.

What are potential errors ? What would be the right approach ?

Thanks in advance

[#7]

Is AGGR(Sum(Revenue),Field) calculating the subtotal of SUM Revenue for each value of the field ? Ex with data

FIELD   REVENUE
Val1     10

Val1     5

Val2     1

I would like to get

FIELD   AGGR(Sum(Revenue),Field)
Val1     15

Val1     15

Val2     1

Is it the case indeed?

[its_anandrjs]

Try like

AGGR(Sum(TOTAL Revenue),Field)

[mahesh_agrawal]

Hi,

Try this expression.

Aggr(if(sum(Revenue)>10K,'More','Less'),[Acc No])

whenever we use IF() in dimension,we have to use Aggr() on the IF().

[#10]

this expression give Null() for all rows...