Excel 2010 Pivot tables - Rows

[skye2511]

Hi everyone,


I have only one column of values but 4 columns of row labels which in 2003 appeared all on one line but now appear over 4. Therefore instead of printing on one page it prints on 4 and I can only filter on the last 'row label' how do I change the layout?


Many thanks


Heather


Row Labels Sum of SGD

1 -1,186,980.44

1 -4,388,346.72

TOURS -4,388,346.72

TURNOVER -4,388,346.72

2 3,201,366.28

TOURS 3,201,366.28

COS 3,201,366.28

 

[NARAYANK991]

Hi Heather ,


Can you please copy + paste here the range in question ? Just 5 or 6 rows and columns of data will do.


Narayan