This content has been marked as final.
Show 1 reply
-
1. Re: Column Date Filter Relevant to Row Date Filter
Shinichiro MurakamiJul 1, 2016 8:56 AM (in response to Andrew McComb)
Here is my approach, but if you have further questions, please let me know.
In my case, I used sum, but you can change it to "countd" or something appropriate.
Set Parameter as date.
Create each calculated Field.
[Day -1]
sum(if [Post Date]=dateadd('day',-1,[Param Date]) then [Value] END)
to
[Day -365]
sum(if [Post Date]=dateadd('day',-365,[Param Date]) then [Value] END)
Thanks,
Shin
9.1 attached.
-
day -1,2,7,_9.1.twbx 41.7 KB
-