Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a straight table with 3 fields. FullName, Purchase and PurchaseAmount. I need to Sum the Purchase and PurchaseAmount fields. I then would like to apply a condition on each field before I display the results. I would only like to see the results where the Sum(Purchase) < 5 AND where the Sum(PurchaseAmount) < 1000.
I have tried using Set Analysis and Calculated Dimensions, but I can't seem to get either way to work. I've attached some sample data if anyone can please provide a solution.
I suggest You Calculated Dimension like
=Aggr(If(Sum(Purchase) < 5 and Sum(PurchaseAmount) < 1000,FullName),FullName)
and check 'Suppress when value is null'.
Regards,
Antonio
I suggest You Calculated Dimension like
=Aggr(If(Sum(Purchase) < 5 and Sum(PurchaseAmount) < 1000,FullName),FullName)
and check 'Suppress when value is null'.
Regards,
Antonio
Or this using set analysis:
Dimension:
Name
Expressions:
=Sum({<Name = {"=Sum(Charge) < 5 and Sum(Amount) < 1000"}>}Charge)
=Sum({<Name = {"=Sum(Charge) < 5 and Sum(Amount) < 1000"}>}Amount)