Hide Sub Total If value is Zero

[gopikrishnach]

Hi,

Here am attaching my qvw file, in i have data and created pivot tables,

Here i want the sub total value and sub total not equal to 0.

If sub total is zero then it should not reflect in Chart.

Please guide me how to do.

[Anil_Babu_Samineni]

Might Sunny busy with some other work

Do you mean this?

Expression 1 by using simple

If(Count(material) >0, Sum(DAY_VALUE))

OR

Expression 2 by Using Set Analysis

Sum({<material = {'=Count(material) > 0'}>} DAY_VALUE)

[gopikrishnach]

No, i want to club both above condition in one expression.

[Anil_Babu_Samineni]

This?

1) If(Sum({<MATERIAL={"=count(MATERIAL)>0"}>} DAY_VALUE) = 0, If(Dimensionality() = 2, Num(0.00000000001, '##.')), Sum({<MATERIAL={"=count(MATERIAL)>0"}>} DAY_VALUE))

2) If(Sum({<MATERIAL={"=count(MATERIAL)>0"}>} MTD_VALUE) = 0, If(Dimensionality() = 2, Num(0.00000000001, '##.')), Sum({<MATERIAL={"=count(MATERIAL)>0"}>} MTD_VALUE))

3) If(Sum({<MATERIAL={"=count(MATERIAL)>0"}>} YTD_VALUE) = 0, If(Dimensionality() = 2, Num(0.00000000001, '##.')), Sum({<MATERIAL={"=count(MATERIAL)>0"}>} YTD_VALUE))

Updated Image

[Anil_Babu_Samineni]

I updated above, Please check enclosed attachment if need

[gopikrishnach]

Anil, i tried with the above expression, but for all materials am getting the Total Values.

Below is my Condition.

If only one Material is present and Material Description is (null) not available in the respective Table, don't want the sub total, If more than one material is available to the respective Indicator than i want the sub total.

I want to display the all Indicators irrespective of Material. i.,e, If material is available and Material Description is not present then it should display.

Please refer below post also...

How to Hide the Sub Filed/Null Filed in Pivot Table

[gopikrishnach]

Can anyone please help me how to club both conditions.