supress data conditionally

[surajdhall]

Hi All,

I have the below straight table showing current and previous month sales.

In the expression showing previous month sales, i want to show only those sales when there is current month sales for that product, ie supress rows that has no sales in current month.

Please help!

[surajdhall]

sorry missed highlighting the row. 

Below highlighted row should be supressed from the chart.

[Gysbert_Wassenaar · Accepted solution]

Use this as the second expression:

If(sum({<MonthYear = {'$(vCurrentMnt)'}>}Margin)/
sum({<MonthYear = {'$(vCurrentMnt)'}>}Sales),
sum({<MonthYear = {'$(vPreviousMnt)'}>}Margin)/
sum({<MonthYear = {'$(vPreviousMnt)'}>}Sales)
)

[surajdhall]

Thank you so much!