Hide rows if specified month sales are greater then zero

[Anonymous]

Hi Guys,

Could you please help me how to hide the row if specify month sale is greater then zero. I have other column in dimension like "Region, District and Company Name".

I put below condition in Dimension Limits to hide the row where the specified month sale is greater than zero. I only want to display where the last three month sales are zero.

But its not hiding the rows.

=
Sum({$<Year={$(=Year)},Month={$(=Month)}>} Sales)=0

kind regards,

Farrukh

[Anil_Babu_Samineni]

You may try this

Num(

          If(

               Sum({<Month = {"$(=AddMonths(Month, -3))"}>}Sales) = 0,

                    Sum({<Month = {"$(=AddMonths(Month, -3))"}>}Sales)

            ),

'#,##00')

[migueldelval]

Hi Farruckh,

I can´t understand you so well,

But maybe you can use: If(Sum({$<Year={$(=Year)},Month={$(=Month)}>} Sales)=0,1, 0) in expression/conditional.

Regards

Miguel del Valle

[Anonymous]

Hi Miguel,

I have 3 dimensions (Region, District & Company Name)

and

3 Expression for Sales eg (Jun, Jul, Aug).

the condition you mentioned above its only hiding the rows for first month sale, but for rest of two previous months showing the sale value.

The result I am trying to produce is where last three months sales are zero. also I put the condition on each expression/conditional but as I mentioned that for the first month is zero and its show the result for other months sales as well.

Farrukh

[Anonymous]

Hi Anil,

I have 3 dimensions (Region, District & Company Name)

and

3 Expression for Sales eg (Jun, Jul, Aug).

the condition you mentioned above its only hiding the rows for first month sale, but for rest of two previous months showing the sale value.

The result I am trying to produce is where last three months sales are zero. also I put the condition on each expression/conditional but as I mentioned that for the first month is zero and its show the result for other months sales as well, which needs to be hide if the sale is greater then zero.

Farrukh

[migueldelval]

Hi Farrukh,

Could you attach an example?

Regards

Miguel del Valle

[Anonymous]

Hi Miguel,

Sorry for the delay, could you please advise me where/how to attach an example here?

I did not find the option to attached or share.

Farrukh