Sue has attended:
Excel Advanced course
Pivot - Formatting
Hi There
Please can you help. I have a pivot table with months and years in the left hand colume and spend in the right hand colume. I need the years to show side by side and not one under the other - as per the example below
Thanks
1 2007 299973.9 197
2008 284887.59 212
1 Total 584861.49 409
2 2007 232262.11 170
2008 243843.22 223
2 Total 476105.33 393
3 2007 365662.05 289
2008 218816.05 213
3 Total 584478.1 502
4 2007 206352.55 176
2008 233447.54 214
4 Total 439800.09 390
5 2007 433659.99 264
2008 224633.1 210
5 Total 658293.09 474
6 2007 297105.8 246
2008 217537.27 217
6 Total 514643.07 463
RE: Pivot - Formatting
Hello Sue
Thank you for your question.
Could you please let me know which fields are in your pivot table (e.g. is there a 2007 field and a 2008 field; or just one Year field) and exactly where the fields are positioned (row fields area, data area etc); or if you can send a copy of the spreadsheet instead that would be helpful. Email address is amanda@stl-training.co.uk if you're able to send the file.
Kind regards
Amanda
