Pivot Table Question

[krehkop]

I'm trying to recreate an existing pivot table and in the Rows window there's a sigma symbol on the 'tile' with the word Values on it. This tile is somehow associated with all of the sums shown in the Values window. If the tile is removed from the Rows window all items in the Values window are automatically removed too. Also, if a new item is added to the Values window it is automatically added (as an indented item) to the pivot table beneath the Source Market field which the first item in the Rows window. Just to be clear, there are two items in the Rows window 1) The Source Market field and 2) the tile with the sigma symbol and the word Values on it.

This is an awesome feature but I have no idea how to recreate it, two other heavy hitters in my group didn't have a clue either.

Thanks for the help.

Kirk

 

[steve the fish]

Put two or more items in the values field. Values should appear in the columns field. Drag it to the rows field.

 

[krehkop]

Thank you Steve the Fish, smh. Can't believe that's all there is to it... Worked like a charm.