6 Replies Latest reply: Oct 24, 2013 10:41 AM by Gysbert Wassenaar RSS

    Create a new dimension

    Javier Florian

      Hi Everyone,

       

      I have the follow information:

       

      Month          Category          Product          Value

      Feb               1                    Emission          $917

      Feb               1                    Cancellation     -$25

      Feb               2                    Emission          $892

      Feb               2                    Cancellation     -$873

       

      So, for business reasons, users need view in a sheet the information filtering Category 1 but in the pivot table Category 1 and Category 2 with Cancellation:

       

      Month          Product          Value

      Feb               Emission          $917

      Feb               Cancellation     -$25

      Feb               2 - Emission    -$873

       

      *Note that sheet has an action filtering Category = 1 when user enable sheet.

       

      I hope be clear with explanation.

       

      Regards,

       

      - Javier