Excluding the values from pivot table

[#1]

Hello all,

I need some help with a small problem.

As you can see below, I need to exclude the value from the dimension. That is in red rectangle, so the values from blue rectangle should not be calculated.

Any help would be nice,

Thanks in advance

[maleksafa]

suppress null values from you chart/dimension

[MK_QSL]

Go to dimension tab

Select your dimension

tick suppress when value is null...

if this is not solving your problem, please provide sample data.

[#4]

On the Dimension tab, Select the "Suppress When Value is Null"