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...
Instead of implicit measure like "Sum of Plans" you may use explicit measure which returns blank if sum is zero, blanks shall not be shown.
- 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] )
