a couple of laughzillas on a blue diamond background

Switching Aggregates in Pivot Fields

Feb06
by on February 6, 2015 at 12:30 pm
Posted In: Around the Web, Keyboard, PivotTables

We’ve all been there. You create a pivot table, add your Values fields, and Excel thinks you want to Count them instead of Sum them just because you have a few blanks. To fix it, you can click the yellow Count of Labor (for example), choose Value Field Settings, and change the aggregate. Or you […]

└ Tags: