Microsoft Office Forums - View Single Post - using 'fill right' to copy formulas in a pivot table, keeping some data elements constant

Thread: using 'fill right' to copy formulas in a pivot table, keeping some data elements constant

View Single Post

Old

12-20-2016, 06:54 PM

Tuph

Tuph is offline

Tuph uses Windows XP

Windows XP Tuph uses Office 2016

Tuph uses Office 2016

Office 2016

Advanced Beginner

Join Date: Dec 2014

Location: Melbourne, Australia

Posts: 31

Tuph is on a distinguished road

Default

The pivot table is calculating correctly. Data can be found in every cell in row 27 so the pivot table is showing 1 for every heading. I have highlighted the row of data in the attached copy of your workbook.

Attached Files

copy of For MS Forums.xlsx (32.6 KB, 15 views)

Reply With Quote