Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Alternatives to MS Query for Pivot Tables & Cubes
I am using Excel 2003. I would like to know if there is an add-in or other
(preferably free) tool out there that I could use to create OLAP cubes for Excel pivot tables that would have better functionality than MS Query. I find MS Query very difficult to use and almost impossible for creating calculated fields that can then be built into a cube. (Note: I thought I could just make calculated fields in the pivot table itself, but now I see that Excel will not let you do that when using an OLAP cube as a source.) Any suggestions would be greatly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Local OLAP cubes in Excel/MS Query | New Users to Excel | |||
pasting into pivot tables query | Excel Discussion (Misc queries) | |||
Updating Query info for pivot tables | Excel Discussion (Misc queries) | |||
Data Cubes and Pivot Tables | Excel Worksheet Functions | |||
Pivot Tables referring to external data query | Excel Discussion (Misc queries) |