Return what level cell in pivot table is

[cogswel__cogs]

I have a macro that references a pivottable for results. However since both fields sometimes might have same name I cannot tell by name if I am in first field or second field. When I hover over the cell it tells me the field being reported. Is there some way in vba to know the level/field that the row of the cell I am grabbing data from is?
I ussually just use classic pivot format to resolve but I love to figure out way to not rely on that format.

Any helps greeatly appreciated.

 

[RoryA]

You can't have two fields in a pivot table with the same name, so I'm not really clear what the issue is. Could you elaborate please?

 

[cogswel__cogs]

No not the field the results in the field.

So say I have a manager named Lewis.
Manager field says Lewis
But also Sales rep might say Lewis.

So when I reference the pivot data cell in a macro - The field could be refering to the Manager or the Sales person.
But I cannot tell which row without visually seeing, is there a way to know in VBA if that row is a manager row or sub-field sales person row. You can tell visually by the indention or hovering over.

 

[cogswel__cogs]

dupped

 

[cogswel__cogs]

Any suggestions on how to do

 

[cogswel__cogs]

Does anyone have a solution to this?

 

[RoryA]

I think you'd need to give an example of the code you are using and what you want as the result.

 

[cogswel__cogs]

I am not using code right now. I am trying to write it now.

 

[cogswel__cogs]

Sorry for the itty bitty picture, above.
I think this might explain better and I really apologize for not being able to explain it more clearly.

If I use get pivot to create formula (below) of the cell I am and the cell below it formula knows that it is reporting (PS_Level_Rollup4 or if it is reporting on PS_Level_Rollup_5 or a subtotal PS_Level_Rollup_4. All I am trying to do is know if the row I am in is a PS_Level_Rollup4 or PS_Level_Rollup5 data.

=GETPIVOTDATA("Count of Current_Year_YTD_Month_End_Actual2",$A$7,"PS_Level_2_Rollup","01-Net Operating Surplus/Deficit","PS_Level_4_Rollup","01-Direct
=GETPIVOTDATA("Count of Current_Year_YTD_Month_End_Actual2",$A$7,"PS_Level_2_Rollup","01-Net Operating Surplus/Deficit","PS_Level_4_Rollup","01-Direct Revenues","PS_Level_5_Rollup","01-Faculty Practice Revenues")

 

[RoryA]

All I am trying to do is know if the row I am in is a PS_Level_Rollup4 or PS_Level_Rollup5 data.

What exactly does that mean? Please be specific: where and how do you want the information returned? Are you trying to use it in a formula? Or something else?