Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table - Finanical information by Period as a month
I have a list of income and expenditure. One field is the month of the
expenditure, just entered as text. This seems to sort beautifully from October to September (being the financial year) apart from April. I inadvertently entered it as 'Apr' initially, whereas I have entered all other months in full - October, November, December..... Even if I go back and edit all the 'Apr' entries to 'April' in the Pivot Table, April is stubbornly on the right hand end of the Table - i.e. at period 12, rather than in column 7, (as it is the 7th period in the financial year). I believe I've also edited the data table and recreated all the Pivot Tables to try to solve the issue, but to no avail. If anyone has any other possible solutions, I'd be very grateful to hear them. Many thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table - Finanical information by Period as a month
Easiest is to just grab April and drag it to the appropriate position...
-- HTH... Jim Thomlinson "DRW" wrote: I have a list of income and expenditure. One field is the month of the expenditure, just entered as text. This seems to sort beautifully from October to September (being the financial year) apart from April. I inadvertently entered it as 'Apr' initially, whereas I have entered all other months in full - October, November, December..... Even if I go back and edit all the 'Apr' entries to 'April' in the Pivot Table, April is stubbornly on the right hand end of the Table - i.e. at period 12, rather than in column 7, (as it is the 7th period in the financial year). I believe I've also edited the data table and recreated all the Pivot Tables to try to solve the issue, but to no avail. If anyone has any other possible solutions, I'd be very grateful to hear them. Many thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table cutting information of a part of the information | Excel Discussion (Misc queries) | |||
Pivot Table moving information | Excel Discussion (Misc queries) | |||
Using the information from a pivot table | Excel Worksheet Functions | |||
pivot table maybe?? combining information | Excel Discussion (Misc queries) | |||
Extracting Information from A Pivot Table | Excel Discussion (Misc queries) |