
1. Re: Comparing Data from Different Rows
Shinichiro Murakami Jan 17, 2016 5:19 PM (in response to Mike Waldren)Mike, Yes, you can.
Assuming your date is only have one day per week.
If not still can be done, but I simplified, If you can share the sample workbook with packaged, I can modify it.
Anyways,
Concept is get current week value and last week value by formula respectively
Calculated the delta of these.
Use parameter to specify "Current Week"
== Steps ==
* Create parameter as "Date" as List added from "Date" Filed.
* Add Three Calculated Fields:
[Current Week Value]
if [Current Week]=[Date] then[Value] END
If you want to put "0" to Null value, if [Current Week]=[Date] then[Value] else 0 END
[Last Week Value]
if [Current Week]7=[Date] then[Value] END
If you want to put "0" to Null value, if [Current Week]7=[Date] then[Value] END
[Current  Last]
sum([Current Week Value])sum([Last Week Value])
To get this results, you need to remove "Date" from column/row because sum calculation for each "Date" resulted in "Null"
and you can not get correct delta in "Current  Last". ==> See "Sheet 1 (not work)"
Version 9.0 is attached.
Thanks,
Shin

Current_Last.twbx 9.9 KB
