Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
povit table colum head
i have a problem in povit table, i have the data like
A sep'06 123 B oct'06 001 C sep'06 101 when i drop this data on the povit table it show l SEP'06 SEP'06 OCT'06 total A 123 123 B 001 001 C 101 101 Y it no show like sep'06 oct'06 total A 123 123 B 001 001 C101 101 please help me out in this proble |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
povit table colum head
Hi
It looks like there is a difference in the 2 values of SEP'06.in the source data. Perhaps one has an extra space. Copy one of the values SEP'06 and paste it to the other cell with that value, then refresh your Pivot Table. -- Regards Roger Govier "Muhammad Usman" <Muhammad wrote in message ... i have a problem in povit table, i have the data like A sep'06 123 B oct'06 001 C sep'06 101 when i drop this data on the povit table it show l SEP'06 SEP'06 OCT'06 total A 123 123 B 001 001 C 101 101 Y it no show like sep'06 oct'06 total A 123 123 B 001 001 C101 101 please help me out in this proble |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom field in Pivot Table? | Excel Discussion (Misc queries) | |||
Pivot Table external XLS file source change and GETPIVOTDATA refresh | Excel Discussion (Misc queries) | |||
Derived Columns in Pivot Table | Excel Discussion (Misc queries) | |||
Change Data In Pivot Table | New Users to Excel | |||
Pivot Tables, Help? | Excel Discussion (Misc queries) |