Yet another way so as to add the exact same industry to your Values region is through the use of a method (also called a calculated column) that uses that very same area while in the formulation. To refresh data on file open Select to have Excel refresh PivotTable facts https://johnd186xva3.bloginder.com/profile