1 Reply Latest reply: Dec 5, 2013 10:17 AM by Srini VEERAVALLI RSS

    How to show two seperate pivot tables with one select column

    62f2bb82-0941-435e-b6ba-5955b09842dc

      Hi All

       

      My client wishes to have two pivot tables, one showing positive results and the other showing negative results.

       

      For Example:

       

      DIMENSION

      BUSINESS A          1000

      BUSINESS B          500

      BUSINESS C          100

       

      DIMENSION

      BUSINESS A          -1000

      BUSINESS B          -500

      BUSINESS C          -100

       

      Is it possible to then select the different DIMENSION with one select column for both?

       

      Thanks