Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Here is what I am trying to do....I have two dimension columns one with unique order numbers another with the payment amount.
If you look at the example below orders 001 and 004 have two entries as Payments were made then refunded.
Basically I want the orders not be shown whereby the total in the payment column equals $0
So in the below example only order 002 and 003 should be shown in the report.
Any help would be great!
Order Number | Payment |
---|---|
001 | $100 |
001 | ($100) |
002 | $345 |
003 | $490 |
004 | $250 |
004 | ($250) |
Hi
Try like this
Use Order Number as dimension
Exp: =if(Sum(Payment) > 0, sum(Payment))
Hope it helps
Hi.
Instead of Order Number you can use calculated dimension:
=aggr(Only({<[Order Number]={"=(Sum(Payment)<>0)"}>} [Order Number]), [Order Number])
also toggle checkbox 'supress when value is null'.
And Instead of using Payment as dimension transform it to expression Sum(Payment).