I have a chart with ResourceName and FutureWeeks as dimensions and RemainingHours as an expression.
The expression is written in such a way that whenever a project ends, the average hours (which the resource had been charging) for that project is released and added to the RemainingHours (ForecastDate dimension has been dragged over the top to show it vertically).
In week of 09/02, one project ends so RemainingHours increases by 2 hours. So RemainingHours will be 9 till the time next project ends (which is in week of 09/30)
In week of 09/30, another project ends and RemainingHours increases by 7 hours. So RemainingHours will be 16 till the time next project ends. (I'm showing RemainingHours for future 26 weeks (6 months)).
My requirement is to show only those weeks where there is a change in RemainingHours.
So for above snapshot, I should get '7' for 07/15, '9' for 09/02 and '16' for 10/07.
Basically, show only the weeks where the RemainingHours change.
Is there a way to do this. I hope I have made my requirement clear.
Any help would be appreciated!