Forum Discussion
magutter
8 years agoRegular Visitor
Custom Columns
I'm tring to create a custom column which uses sum(Sales) but want to filter on another column call type where it shows everything EXCEPT Types that equal "JC" or "JD". Tried the following syntax bu...
v-jiascu-msft
8 years agoMicrosoft Employee
Which result do you want?
Best Regards,
Dale
magutter
8 years agoRegular Visitor
Hi Dale
I want it to get the NET figure for Sales but exclude TYPE of "JC" or "JD". I want those types to return a value of 0