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
Bookmarks