PivotTable Field/Data Heirarchy

[SkipVought]

I have a PivotTable

Sum of feqh | [red]WA Group [/red]|  [blue]Act/Fcst   |[/blue]
------------+----------+-------------+[red]   	
            |  (3E79   |             | 
            |    /     |             |
            |   3G20)  |    FLEET    |[/red]
------------+----------+------+------+   	
MONTH       |  [blue]Fcst    | Acts | Fcst |[/blue]
------------+----------+------+------+

WA Group & Act/Fcst are Column Fields.

I need to COUNT the number of Act/Fcst Items for each WA Group Item. In the above example, Wa Item (3W79/3G20) has ONE Act/Fcst Item: Fcst, while FLEET has 2: Acts & Fcst.

My objective is to Center across Selection each WA Group Item -- so in the example (3W79/3G20)is centered across ONE cell while FLEET is centered across TWO cells. Co if there's a way OTHER THAN counting, as requested above, I am open to your suggestion(s).

Thanx, as always!

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[SkipVought]

Well, I figured out that I could Enable Selection for the PivotField WA Group and set the Horizontal Alignment there.



Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884