Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Can u share your application? Format of Aggr() depends on the no. of dimensions used.