I need to perform a basic division but using two different pivot tables. Pivot Table A represents number of stores with different values. The number of stores will fluctuate on a weekly basis (increasing or reducing). Pivot table B has the exact the same format but number of stores stays the same. Please refer to the attached file. Thanks! Vlookup---Pivot-Table.xlsx
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.