Hi All

I have provided the below URL to access the sample File. Basically I have two pivot tables with different Views ie One comparing the Actual Vs Budget while the other compares Forecast VS Budget. I wish to combine the two so that I can toggle the view with VBA Code. This is powerpivot table inserted through the data model. I'm aware of the DAX Switch formula to toggle the measure but this wouldn't help me in changing the Data Label hence I have turned to look for a VBA approach.
Also I need a macro to apply different conditional formatting based on the Row label of the pivot table. To illustrate further, I need 3 Arrows Coloured icons sets with an opposite conditional rule to apply for Cost to the one I would have for Sales & Gross Profit.

The requirements have been described in the sample file.

Any help is highly appreciated

Thanks
Krishna



https://drive.google.com/file/d/0B7c...ew?usp=sharing