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

[sunny_talwar · Accepted solution]

This?

[sunny_talwar]

I also want to thank you for consistently sharing samples with your post. A lot of the times people don't share  a sample making our job so much more difficult. From all the people I try to help, I love those who provide most of the details. Input, output and qvw.

Once again thanks for doing this and continue the good work.

Best,

Sunny

[rahulpawarb]

Simple and Effective (As always!)

[devarasu07]

Hi stalwar1‌

In my case, i've more than outlet(exactly30 outlets) and one warehouse so tried to updated the if conditional and it's not giving expected result. do you have any idea? Thanks

Tried with below expression

=Pick(Dim, If(Outlet = 'T2' or Outlet= 'T3', 'Sold Qty'), 'SOH')

//=Pick(Dim, If(Outlet = 'T2', 'Sold Qty'), 'SOH')

Thanks,

Deva

[sunny_talwar]

Would you be able to point out what the expected output needs to look like?

[devarasu07]

Hi stalwar1‌

by using below expression getting correct result but instead of Measure Column header it's shows number (dim table values). how to change below highlighted numbers to "Sold Qty" for all outlets expected CKS-WHS(only SOH measure)

=Pick(Dim, Match(Outlet, 'ION','313','NEX','CWP','CTL','MBS','T2','T3', 'Sold Qty'), 'SOH')

and also need to show Total at the right side(all stores total by each materiel).

Thanks,

Deva

[sunny_talwar]

Which total are you looking to get? Both Sold Qty and SOH?

=Pick(Dim, If(Match(Outlet, 'ION','313','NEX','CWP','CTL','MBS','T2','T3'), 'Sold Qty'), 'SOH')

[devarasu07]

Hi Sunny,

Thanks, Yeah looking for both Sold Qty and SOH total at end.

Thanks,Deva

[sunny_talwar]

May be this