Someone has dona pivot table for me. they have done it like this...
........................... PRJ No
............................ A ....... B ........ C ........ D ....... TOT
Data
Count of Sep-06 ... 1 ........ 2........ 2....... 1 ....... 6
Count of Oct-06 ... 2 ........0........ 3......... 4 ....... 9
Count of Nov-06
Count of Dec-06
Count of Jan-07
Count of Feb-07
Count of Mar-07
Count of Apr-07
Count of May-07
Count of Jun-07
Count of Jul-07
And so on.....
My question is... how did they get the "count of months" down the left...?
I have tried dragging the months data- its not working for me... must it be formatted in a certain way? i.e. SUM or COUNT..!?
Thanks
........................... PRJ No
............................ A ....... B ........ C ........ D ....... TOT
Data
Count of Sep-06 ... 1 ........ 2........ 2....... 1 ....... 6
Count of Oct-06 ... 2 ........0........ 3......... 4 ....... 9
Count of Nov-06
Count of Dec-06
Count of Jan-07
Count of Feb-07
Count of Mar-07
Count of Apr-07
Count of May-07
Count of Jun-07
Count of Jul-07
And so on.....
My question is... how did they get the "count of months" down the left...?
I have tried dragging the months data- its not working for me... must it be formatted in a certain way? i.e. SUM or COUNT..!?
Thanks