This content has been marked as final. Show 2 replies
I'm trying to create a pie chart that sums all of a certain amount, exlcuding records for which "Package Config" = "No Package". The "Package Config" dimension is not used in the pie chart, just Supplier. The weird thing is: if I apply the formula below to a bar graph that has "Package Config" as one of the dimensions, it works perfectly.
Here is my attempt (not working for pie charts):
=if(not(PACKAGE_CONFIG = 'No Package'),sum(TOTAL_ALLOCATION))
What am I doing wrong? Can the IF NOT function only be used if the chart includes the dimension that I'm trying to qualify?
Also: I would love to do this using Set Analysis, but don't know how.