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.

[sunny_talwar]

So you only want the total row to disappear here? But still want to see the individual row with 0s?

[gopikrishnach]

Yes, I don't want row which are having value=0

[sunny_talwar]

rows or total rows?

[sunny_talwar]

Selecting 'Suppress Zero-Values' on the Presentation tab removed all the rows with 0

[gopikrishnach]

i don't want sub Total Value which are having zero.

Example: i want display the material name with zero, but i don't want the rows which are having the sub Total as zero.

[gopikrishnach]

if i pick the Suppress Zero-Values the entire table is not coming,

Example: i want display the material name with zero, but i don't want the rows which are having the sub Total as zero.

[sunny_talwar]

Here you go

Expression:

If(Sum(DAY_VALUE) = 0, If(Dimensionality() = 2, Num(0.00000000001, '##.')), Sum(DAY_VALUE))

[gopikrishnach]

I got it. Thank you Sunny T

[gopikrishnach]

Here i have one more condition, if the count(material) is ">"0, then only i want the sub total. Please review.