I am creating a graph of 'cumulative planned' vs 'cumulative actual' on a month by month basis. Can I get rid of the duplicates in the PivotTable/Chart where it is future months? I would li... ohorton I mean using of measures like Total Planned:=VAR planned=SUM(Table1[P...
Planned vs. Actual in Google Sheets and Excel Online Update 3/19/2019: Although cross-hatching isn't currently possible as a conditional formatting option in Google Sheets (or Excel Online), I figured out how to implement it using text ("///"). So, the Pro version includes th...
I am creating a graph of 'cumulative planned' vs 'cumulative actual' on a month by month basis. Can I get rid of the duplicates in the PivotTable/Chart where it is future months? I would like to keep it as a PivotChart if possible as I have multiple slicers and want to keep the...
Planned vs. Actual in Google Sheets and Excel Online Update 3/19/2019: Although cross-hatching isn't currently possible as a conditional formatting option in Google Sheets (or Excel Online), I figured out how to implement it using text ("///"). So, the Pro version includes the ...
I am creating a graph of 'cumulative planned' vs 'cumulative actual' on a month by month basis. Can I get rid of the duplicates in the PivotTable/Chart where it is future months? I would like to keep it as a PivotChart if possible as I have multiple slicers and want to keep the...