Pivot Table - Add Multiple Fields to Values Tab

Hello all,

I was wondering if it were at all possible to add multiple columns to the values portion of a pivot table at once, instead of individually dragging. When you click on them, it auto-sends them to Row Labels, which I don't want. I have a bunch of columms I want to add to Values and don't want to waste a bunch of time dragging them invidiually. Let me know if this is possible.

Thanks!

Hi Shadefalcon,

I am assuming that the "Value" (when you click on them, it auto-sends them to Row Labels) is a Field in the Pivot Table Field List.
Instead of clicking, drag the value field into the Column Labels box.
If this isn't what you want can you attach a desensitised copy of your worksheet.

Regards

peterrc

Hey Peterrc,

I'm having the same issue as OP. I need to select all Month Year (MMM YY) fields (i.e. Jan 13, Feb 13, etc) and add them to the Values quadrant.

1) Can I select multiple fields at the same time (rather than dragging each one individually)?

2) If the answer to question #1 is no, then can I adjust my preferences to to place field selections into the Values quadrant (rather than the Rows quadrant)?

3) Can I change the default options to change the Values quadrant's function to SUM (rather than Count)? I'd like to avoid having to manually change each field's calculation function.

Thanks in advance,

FJ

example.jpg