Problem with null values in pivot chart

[saimahasan]

Hi All,

I have a pivot chart wherein i have made all 0's as null in my expression.

Now when i am trying to suppress null values, its not suppressing the row when its all nulls in that row.

Please find below the screenshot for my problem statement.

Since "Structured Rates" and "Non FIC" are non null in CYTD16 dimension value, its not even suppressing these columns under CYTD17 dimension values also.

Please help.

[MK_QSL]

Provide sample file or sample app.

[dineshm030]

Hi,

Please attach your QVW.

[saimahasan]

Hi

I cannot share the sample app since it has confidential data.

In general terms, if you all can suggest what can be done??

I have explicitly made the expression value as null wherever it comes to 0 by using null().

Now when i am suppressing Null values from dimensions tab, i am not able to suppress those rows where i have explicitly made them null.

[MK_QSL]

Yes.. you can't share confidential data.

But you can create few lines of dummy data and can share here.