I am trying to round a pivot table formula to the thousands. How do I incorporate the =ROUND(below,-3)?
Here's the formula
=(GETPIVOTDATA("Annual Budget",Bgt_Mattress!$A$3,"Store","1001 - Nitey-Nite Miami")+GETPIVOTDATA("Annual Budget",Bgt_Pillow!$A$3,"Store","1001 - Nitey-Nite Miami")+GETPIVOTDATA("Annual Budget",Bgt_Other!$A$3,"Store","1001 - Nitey-Nite Miami"))*F5
Solved by C. U. in 21 mins