Conditional Dimension

[#1]

Hi All,

I need to list onlythe countries where sales is <= 0,

For that in Dimension i used like this but it not working,

if((Sum(Sales))<=0, Country) and in expression Sum(Sales)

What's wrong in this..

Thanks,

Selva

[er_mohit · Accepted solution]

try this

aggr(if(Sales<=0,Country),fieldname) here fieldname you use that you want to get output on the basis of that

if you didnt get then,

use that in expression with using aggr function means on the basis of that field you want and try this

aggr(if(Sales<=0,Country),basefieldname)

[#3]

Hi,

You can not aggregation function directly in dimention.

So use in dimension : if( Aggr(sum(Sales),Country) <=0,Country)

Niranjan M.

[Anonymous]

Hi Selvakumar

To list only the countries with sales<=0, You can change your expression as Sum(If(Sales<=0, Sales))

Hope it helps you

Regards

Revathy

[Anonymous]

Hi,

please find theattachment of application,zero will be supress to add a calulation dimension and in presentation tab supress zero check box will be check.

it will be work for you.

other wise please send the test data, i will work on the test data.

Regards

SHAIK

[#6]

Hi All,

Thanks for the quick response

Both Mohit and Niranjan solution worked.

Selva

[jagan]

Hi Selva,

Try this using set analysis

=Sum({<Sales={'<=0'}>}Sales)

Hope this helps you.

Regards,

Jagan.