Hi,
I am trying to compare two calculated fields that are driven by date parameters, fuel economy from a "Baseline Period" against the fuel economy of a defined "Current Period"
I want the Baseline Period result to remain static whilst i am able to change the current period at will?
When i drop in the time period as week into the row shelf, i want to view the benchmark fuel result and calculate difference against current period??
I have attached packaged WB
Aaron
5 answers
see below - the third column is the calculation