1 Reply Latest reply: May 22, 2017 8:00 AM by Vineeth Pujari RSS

    Pivot Table based on data availability

    Aishwarya R

       

      Hi,

       

      I have the below data.

         

      LoBTier 1Tier 2Tier 3Tier 4Tier 5
      CSaaabbb
      RMcccddd
      PCeeefffggg
      TH1hhhiiijjjkkkqqq
      TH2lllmmmnnnoooppp

       

       

       

      Now, I should show this in the form of pivot table as below. And provide Lob as a filter.

       

      How to achieve this based on the selection of the Lob filter?

       

       

      Currently what is happening is, since no data available for tier 3 tier 4 tier 5 , the drill down shows null values.

       

      Thanks