Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone ,
IF(SUM({<[TRANSACTION_TYPE] = {'SALE'}, [NET_AMOUNT] = {">=5000000"}>} [NET_AMOUNT]),'GREATER','LESS')
i've this expression and i want to use this as a dimension or as a filter in dashboard ,
@mahnoor1279 May be you can try to create a flag using the same expression in your load script something like below:
Load *,
if(([TRANSACTION_TYPE] ='SALE' and sum([NET_AMOUNT])>=5000000),'GREATER','LESS) as Flag
From Table_Name
Group by Fields;
In the front end you can use the Flag as a filter or Dimension.
If this resolves your issue please like and accept it as a solution.