Hi,
I am looking to use the below formula to auto update my cells based on the date. I am missing something and I'm not sure what it is. I keep getting a dash(-) instead of the number that it should be. Can someone help me? I used the below calculation please help =IFERROR(GETPIVOTDATA("[Measures].[Sum of exit_count]",'Exits Data'!$F$11,"[Exits New Customers].[initiation_month_name]","[Exits New Customers].[initiation_month_name].&[Jan-20]","[Exits New Customers].[FinCrime_indicator]","[Exits New Customers].[FinCrime_indicator].&[Financial Crimes],.&["&TEXT($C$3,"mmm-yy")&"]"),"-")
I am looking to use the below formula to auto update my cells based on the date. I am missing something and I'm not sure what it is. I keep getting a dash(-) instead of the number that it should be. Can someone help me? I used the below calculation please help =IFERROR(GETPIVOTDATA("[Measures].[Sum of exit_count]",'Exits Data'!$F$11,"[Exits New Customers].[initiation_month_name]","[Exits New Customers].[initiation_month_name].&[Jan-20]","[Exits New Customers].[FinCrime_indicator]","[Exits New Customers].[FinCrime_indicator].&[Financial Crimes],.&["&TEXT($C$3,"mmm-yy")&"]"),"-")