Hi
I am trying to build a visual that compares data for the last few forecasts. What I would like to do is to add a column at the end that compares the previous forecast to the current forecast with the change that I could conditionally format.
Tried creating a measure that does this calculation and the filtering on this measure in the visual filters to hide for the other forecasts but this did not hide the columns for B01 (it also puts the change in both the F04 and F06 cols, one is a +ve and one is a -ve). Any ideas on how to do this.
Additionally - Is there anyway to hide the heading on column 1(if i turn off column headings I lose my forecast labels. I tried to add a picture below, trying to remove all of the yellow areas.
thanks