microsoft.public.mac.office.excel - Microsoft products for Macintosh
I have a pivot table that has a date field that is coming up out of order. The column is labeled week ending data and the week of 7/10/09 is coming up before 7/3/09. I need to get this back in line because it is throwing my charts off. Can you tell me what to do to correct it.
I have what is probably a unique question, and kind of hard to explain, so I have included a sample of how it should look. I have data in a pivot table on Excel. It consists of employee 3, a pay code, and hours belonging to that pay code. Each employee could have 1, 2, 3 (or more) rows of data. I want the copy the employee's hours within the pivot table to columns that are not within the pivot table. All of the hours have to show up on the top row for that employee, and under a column specific to that pay code. Below, I have a sample of how I want this to look: (columns A, B, and C contain the pivot table; columns D and on are where I want to copy the hours from column C. The hours should be copied to the top row for that employee; and to the column that corresponds to the code indicated in column B A B C D E F G 1 REG HCC ITC SCC 2 3 ID Code Hours 4 123 REG 57.10 57.10 5.82 22.43 5 ITC 22.43 6 HCC 5.82 7 8 456 REG 62.25 62.25 27.15 3.5 9 ITC 27.15 10 SCC 3.50 11 12 789 REG 61.50 61.50 25.6 13 ITC 25.6
I have created a pivot table. Next to the pivot table are columns to enter data and then additional clolumns to add the pivot table and not pivot table data. I am running a filter on a column in the pivot table, and the non pivot table data entered does not hold with the pivot table line. (For example, I have an line in the pivot table (say line 20) call "item 1". I enter a value in a Column outside the pivot table to correspond to item 1 on line 20. When I filter on "item 1" - it now moves to line 5; however, the amount I manually added to line 20 outside the pivot table stays on line 20, but I want it to move to line 5 with the pivot table data
I have been able to reduce the file size by unclicking the option "save data in pivot table". I can't seem to find an article on the web that will explain to me if I will lose functionality of the pivot table if I turn this option off. Can you help?