PDA

View Full Version : Pivot table Help



countryfan_n
09-25-2010, 05:21 AM
Hello friends,

I need your help. I have the attachment that has a sample of all my songs.
I want a "pivot table" that would tell me how many albums do I own by Genre then by artist, I keep getting the number of songs instead. Please help me with the following points in mind:
A. (Col. F) or Genre need to be in "Row labels".
B. (Col. D) or Artist needs to follow the "A" condition and also needs to be in "Row labels".

Thank you so much in advance!
Nawaf

Bob Phillips
09-25-2010, 08:59 AM
Try this