Darkcloud617
New Member
- Joined
- Sep 7, 2017
- Messages
- 38
Hello,
I am using a pivot table that is an object so a certain area can be grouped. When I reference a cell in the pivot table it returns this:
The issue is that I need this formula to by dynamic by the "Audit Period" month. I tried to add a cell reference (which contains the month) and that is at cell "[BK119]". In cell "[BK119]" it says "Jan".
Any ideas on adding a dynamic reference to a pivot table formula like this? It would be greatly appreciated.
I am using a pivot table that is an object so a certain area can be grouped. When I reference a cell in the pivot table it returns this:
Excel Formula:
=GETPIVOTDATA("[Measures].[Distinct Count of Number]",$AY$119,"[Range].[Audit Period (Month)]","[Range].[Audit Period (Month)].&"[BK119]","[Range].[Loan Type]","[Range].[Type].&[Default]")
The issue is that I need this formula to by dynamic by the "Audit Period" month. I tried to add a cell reference (which contains the month) and that is at cell "[BK119]". In cell "[BK119]" it says "Jan".
Any ideas on adding a dynamic reference to a pivot table formula like this? It would be greatly appreciated.