Hello,
I am trying to generate a pivot table for a skills matrix and everything is working EXCEPT the value fields portion of the matrix is not just displaying the values from the SQL query it is performing a count. When I go into the Pivot Tools Summarize values there is no option to NOT summarize so instead of getting the value from SQL query I get a 1.
In other words I want this and again my sql query has this information exactly correct.
Joe Jane Bob Tie Shoes E B C Blow Nose E E Drive Car P
What I get is this:
Joe Jane Bob Tie Shoes 1 1 1 Blow Nose 1 1 Drive Car 1
Just a little nudge I think should do the trick
TIA
JB
Bookmarks