cogswel__cogs
Board Regular
- Joined
- Jan 3, 2018
- Messages
- 168
cell(e5) =GETPIVOTDATA("TXN Procedure Count",$A$3,"Financial SubDiv Name","IMMUNOLOGY")
cell(e6) =GETPIVOTDATA("TXN Procedure Count",$A$3,"Financial SubDiv Name","IMMUNOLOGY" ,"DX CODE","L27.2")
When I am in a cell and I click "-" and on pivot table data the get pivot function knows what "Field/position" level the data is on.
Is there a way for me in VBA to identify what (field/level) a particular cells data is for?
cell(e6) =GETPIVOTDATA("TXN Procedure Count",$A$3,"Financial SubDiv Name","IMMUNOLOGY" ,"DX CODE","L27.2")
When I am in a cell and I click "-" and on pivot table data the get pivot function knows what "Field/position" level the data is on.
Is there a way for me in VBA to identify what (field/level) a particular cells data is for?