Forum Discussion
Cumulative Planned vs Actual Pivot Graph
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...
Sergei, thanks for your response but could you please elaborate. I'm not sure I quite understand what you are saying
I mean using of measures like
Total Planned:=VAR planned=SUM(Table1[Plan] ) RETURN IF( planned, planned, BLANK() )
Total Actual:=SUM( Table1[Actual] )