Not able to supress

[nareshthavidishetty]

Hi,

We are using pivot table actually there is no null in the dimensions Market,Location and Date fields but when i created an pivot chart it is showing null and i need to remove the null column.

Below is the image for reference.

Thanks..

[Chanty4u]

Hi,

supress the row when the value of column is null?

In this case you put in the dimension the expresion:

if(IsNull(expresion, Null(), Dimension)

and select the option to supress if is null

[ElizaF]

Check the the option "Suppress When Value is Null" from Dimensions tabs of the chart.

See below the image:

[nareshthavidishetty]

Hi,

I don't want to suppress null values as i need markets which don't have sales as well.

Thanks..

[gireesh1216]

Hey Naresh,

Each and every dimension you need to check "Suppress When Value is Null".Then only it will work

[jyothish8807]

Hi Naresh,

Select supress null value only for Dimension "Date" and give it a try.

Also fro presentation tab check " supress zero value".

Br,

KC

[chhavi376]

Hi Naresh,

You can "Suppress When Value is Null" only in 'Month' dimension.

Also, if you could please upload the QV for a better understanding.

Thanks,

Chhavi