Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Excel 2002 Pivot Chart
I will answer my own question...it appears that this could be a bug in excel. One way to get around it is to create a macro that applies all of the formatting. If you want this macro to be driven automatically, call the macro from the worksheet's change handler (the one that contains the pivot...- Bryan2662
- Post #2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Excel 2002 Pivot Chart
I'm using a pivot chart in Excel 2002. Whenever I change one of the pivot fields, the formatting of the data on the chart is lost. Even though I set the data lines to custom, the pivot fields seem to reset them when they are changed. Thanks!- Bryan2662
- Thread
- Replies: 2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Counting Fields in Analysis Services
I'm just reading through the tutorials for the first time with OLAP. I came across the calculated member section and wondered how you can sum up data across an ID number. For example, I have an employer and within that employer group, a set of employees. Is there a way to have the number of...
