3 Replies Latest reply: Dec 12, 2013 12:34 PM by Vlad Gutkovsky RSS

    Limiting the dimension values in pivot table.

    Abhishek Agarwal

      Hi All,

       

      I'm trying to create a pivot table chart in which the dimension is Region and their values are APAC,EMEA,NA and LATAM and I'm summing the sales value for these dimensions over another dimension which is year. Now only APAC is divided into APAC, APAC Direct and APAC Channel.

       

      Now:

       

      1. I'm trying to come up with single APAC value which should have the sum of sales for APAC + APAC Direct + APAC Channel

      2. Is it possible to show only APAC value in pivot table but the final sum should show the sum for APAC Direct and APAC Channel also.

       

      Please suggest!!!

       

      -Abhishek