Show values dimension when the measure is zero

[Shi]

Hi to everyone!

I have an issue.

I have a Measure= 'Volumes', a dimension MONTH and VALUE.  In a TABLE CHART  I want to show values for MONTH dimension only when sum of  Volumes =0

I tried the following expression, but it seems that Qlik sense doesn't show rows when the measure it's equal to zero.

if (aggr (Sum ({$ <Measure = {'Volumes'}>} VALUE), MONTH) =0, MONTH)

I tried already the option Include zero values in the data handling, but it doesn't work.

Thanks  a lot!

[PriyankaShivhare]

if(sum(volumes)=0,Value,sum(Volumes))
may be u can put ur requirement as current table set and expected table set.

[Anil_Babu_Samineni]

Try this

Dimension : MONTH

Expression : Sum({<MONTH={"=Sum(Volumes)=0"}>} Volumes) OR

                          Sum({<MONTH={"=Len(Sum(Volumes))=0"}>} Volumes)