9 Replies Latest reply: May 22, 2015 1:54 AM by Ravi Kumar RSS

    How to hide row(s) based on condition in Pivot Table.

      Hi I have created a pivot table like below with sample data. but when ROLE has more than one SPECIALZATION then that complete ROLE has to hided.

      i.e., in the below example "EG Service Provider ISR" has to be removed as contains more than one (i.e,, two) SPECIALZATION.

       

       

      Currently We have like this.

      We wanna remove like below:

       

       

      So Result is like this:

       

      Note: This would be dynamic, not static.

       

       

      I attached sample QVW and Source for the same. please do changes accordingly. Please do reply early.

       

       

      Thanks,