Hi,
ive been stuck on this pivot table from last 2 days...would appreciate any help...
I've a list of boxes with planned and actual dates..( There are 8 sectors and 300 boxes each..)
What I want to show on the pivot table is two rows for each sector: one row for total no of planned boxes and other for total no of actual boxes against Months in the column
In the attached file,I have managed to show planned boxes against time but cant find a away to show actuals over the same time period.
Please help...
Bookmarks