Hi,
Please see attached example worksheet - I have data showing hours used over a number of months for some sites - I want to create a pivot chart to all for breakdown, overall or by site, but when creating the pivot (see sheet 2) the filter for month displays values and I have tried to correct to no avail....
Any advice is appreciated.
I suggest taking a small part of the data, say sites 1 and 4, and manually showing us what you want the pivot table to display for those two sites.
If we can come up with a way to make that work, then it is possible that solution can be applied to the whole data range on Sheet1.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks