Blank Column in pivot when using calculated dimension

[guyvermeiren]

Hello,

I created a pivot table using a calculated dimension.

When totally collapsed the table occurs with a blank column after the first (calculated) dimension.

What's the reason for this ?

Thanks

Guy

[Channa]

is it possible to share APP or sample data or expression

[guyvermeiren]

This is the expression for the calculated dimension:

=if(Match([Organization],'Belgium','Netherlands','France','Germany'),[Account Mngr],null())

Kind regards,

Guy

[Channa]

Try remove else null
Try with out calculation do you have customers for west, North... Check