Hi,
I'm trying to get a =GETPIVOTDATA formula to update daily based upon todays date but am struggling.
The data feeds from a SQL DataMart and the formula is:
=GETPIVOTDATA("[Measures].[Case Completed -Invoiced - Count]",SBVSDATA!$A$6,"[Time].[Day]","[Time].[Day].&[25]","[Lender].[MI...