| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Row Field Format (OLAP Source)
That's solved it! Many thanks for taking the time.
"johnE" wrote: The problem is in your cube. Edit the dimension in your cube and change the ordering to the key for the number of days. Key fields get sorted numericaly. Thsi took me a while to figure out. "Adrian Morris" wrote: I have a pivot table linked to an OLAP cube. In this instance, my only row field contains numbers (the number of days taken to complete a task) and all I want to do is display a count for each total (i.e. 234 items took 1 day, 345 took 2 etc). The problem is that these numbers are listed as text, therefore 1,10,100,11 instead of 1,2,3. In view of the number of days, I'm trying to avoid manually adjusting the list. Apart from importing the source data into Excel rather than using the cube, is there any way to get around this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot table formats text data with 2 decimals | Excel Discussion (Misc queries) | |||
| Pivot Table for survey results with set of possible answers in PT's Rows Field? | Excel Discussion (Misc queries) | |||
| Calculated field in pivot table | Excel Discussion (Misc queries) | |||
| Creating Calculations Within a Pivot Table Field | Excel Discussion (Misc queries) | |||
| I cannot drag a Pivot Table field into the page area | Excel Discussion (Misc queries) | |||
Threaded Mode
