Is there a way to get a pivot table data point using a formula with a filter set in the pivot table.
As an example, in my pivot table i have a row called % of total which analyzes my data for all days of the week. If i wanted to pull into a formula what the % of total is for an entity on only monday's, is that possible with the GETPIVOTDATA and if so what is the format of the formula...i tried this and it did not work: =GETPIVOTDATA("PctofTotal",PivotTableName,"Hour",8,DayofWeek,2) where dayofweek is filter on the pivot table. If I cut off the formula at "hour",8) the it works. Just trying to figure out how to reference a pivottable value with a filter applied
As an example, in my pivot table i have a row called % of total which analyzes my data for all days of the week. If i wanted to pull into a formula what the % of total is for an entity on only monday's, is that possible with the GETPIVOTDATA and if so what is the format of the formula...i tried this and it did not work: =GETPIVOTDATA("PctofTotal",PivotTableName,"Hour",8,DayofWeek,2) where dayofweek is filter on the pivot table. If I cut off the formula at "hour",8) the it works. Just trying to figure out how to reference a pivottable value with a filter applied