This content has been marked as final. Show 10 replies
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.