Transform 0 as Null under specific condition

[#1]

Hello Community,

I am now doing a combo chart and encounter a problem related to the line. There 2 dimensions in the graph, one is the Period, another is the Scenario. Scenario is divided into Actual ('A') and Plan ('P') data, which is required to show in the bars. However, for the line, it is only required to show the 'A' figure rather than both 'A' and 'P' and I did it by getting 'A' data with set analysis. From the picture below, you can tell the outcome is a bit strange because 'P' is shown as 0 through the line for each period, and that is not what I expect to see.

I have tried to use the suppress 0 function but it may affect the bar chart part to show 0, so suppress 0 function is not a solution for my problem. How can I fix this?

Thanks

Maverick

[avinashelite]

Try with if condition like

if(Scenario='P',null(),your set analysis expression for A)

[swuehl]

Try something like

Sum(TOTAL<Period> {<Scenario = {'A'}>} Value)