Pivot Table -- Adding Filter

**jph89** · 09-12-2012, 02:21 PM

I am trying to play around with different states/lead sources in a pivot table. I would like to be able to select 1,2 or all 3 lead sources along with however many states I'd like to see final outcome. Whenever I add the 'state' to the filter, it removes the state name in column A.

Can anyone take a stab at this? Thank you very much in advance, I appreciate everyone's time.

**Max, Singapore** · 09-12-2012, 11:30 PM

Try tinkering like this ...
First, in your source data table, extend it by repeating* the 2 cols concerned, viz: Lead Source, State
Label the repeat col headers simply as, say: Lead Source1, State1
Then pivot on the extended table as per your original, except that this time around use/place the 2 repeat col headers into the Report Filter instead
*via copy n paste special as values
----------------
Success? Wave it, hit the little star at the bottom left of my response