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

    Dimension limit in a chart object

    Rani Bosch



      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