3 Replies Latest reply: Feb 1, 2016 12:36 PM by Gysbert Wassenaar RSS

    How to show missing dimension in pivot table

    Alex Xie

      Currently, we have a pivot table, it will show all dimension value when all has value.

      Some dimension value will hide after we select period time.

       

      e.g.

      Dimension 1 asset risk: High, Medium, Low

      Dimension 2 client risk: High, Medium, Low

       

      Table format:

       

       

      Client Risk   High     Medium     Low

      Asset Risk

      High               3        6              4     

       

      Medium          4        7              2

       

      Low               5         8              7

       

       

      /////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

      It will be shown as below after select period time

       

      Client Risk      Medium     Low

      Asset Risk

      High               6              4     

       

      Medium         7              2

       

      Low               8              7

       

       

      My problem is, how to show null value or missing value for Client Risk dimension. And want to show it as below after select period time.

       

      Client Risk   High     Medium     Low

      Asset Risk

      High               0        6              4     

       

      Medium          0        7              2

       

      Low                0         8              7

       

      Is there any approach to solve above problem?