Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Determine data type for Pivot Field
I would like to know how to get detailed data type information from a
pivot field. The Pivot table is based on an OLAP cube from Analysis Services. I need to be able to format a number as either a currency or a count. The source measure in Analysis Services has this meta data for the data type but I cannot find it from within Excel. I am using VBA to write a custom macro to do the formatting, and have scoured the web, MSDN and various books, I just cannot seem to find the answer. I have found the PivotField.Datatype property but it only holds one of three values, Date, Text or Number. I need to determine what type of number the field is, currency or count. Thanks! Mike Dudash |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reverse Pivot-type Data (that's not a pivot table) | Excel Discussion (Misc queries) | |||
Pivot Field in Field List but Not Source Data | Excel Discussion (Misc queries) | |||
Missing Pivot Data in Pivot Field (PF)-Weird! | Excel Discussion (Misc queries) | |||
How to type correctly formula in calculated field in a pivot? | Excel Worksheet Functions | |||
determine cell is part of pivot item or pivot field | Excel Programming |