Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
My data in QVD looks like below:
Sales Order Cost Category Values
1000 A 100
1000 B 200
1000 C 300
1000 D 400
2000 A 100
2000 B 200
2000 C 300
If the Sales Order has Cost Category D then my report should not show Sales Order 1000. My report output should only show data for sales order 2000.
I tried following calculated dimension with following syntax but its not working:
= if(Cost Category = 'D', null(),Sales Order)
Any help is appreciated.
Hi,
see this example.
You now able to select the values you need.
Good Luck!
Rainer