1 Reply Latest reply: Oct 18, 2017 8:46 AM by Sunny Talwar RSS

    Dimension limit in a chart object

    Rani Bosch

      Hi,

       

      I want to create a pivot table for a specific business unit.

       

      I do not want to limit my business units in my script, as I need all the data for another sheet in my model.

       

      How do I limit the dimension to only look at the specific business unit called WWS?

       

      The pivot table currently gives the WWS seperate from the rest of the BU's , whilst the total pivot table balances to the total sales amount.

       

      See attached a screenshot of my object below