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