Hello,
On my sheet Row 10 to Row 33 are hours of the day. midnight, 1,2,3, etc. Row 34 is the grand total for each column of data. The Columns are B (under 15 mins), C Under 30 mins) etc. with K being the some of all loads for that hour. and L being the percentage of each hour. I need Row 35 to be a percentage of the grant total for each row of the grant total of all columns from B thru J, which is in K34.
It always helps to include a sample workbook so people can visualize the problem better. Pictures are nice too, but people are not going to take the time to retype data that you probably already have. Also there are nuances like formulas, restrictions, etc. that don't show up in pictures. When it comes to pivot table questions, a sample workbook is doubly important. We need to see the layout of both the pivot table and the source data.
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks