Pivot table Hide measure column based on dimension value?

[devarasu07]

Hi,

In Pivot table, Is there any way to hide measure based on one dimension value?

Please refer to the attachment,

Example, if Outlet is WH then need to show only SOH measure (based on dimension value need to hide specific measure in pivot table)

Note: i don't want to use macros option.

Thanks, Dev

[devarasu07]

Hi stalwar1‌,

Perfect. It's working like a charm. Thanks

Regards,

Deva