Can this be the simple solution?
[Date_Filtered] // ==> then put into Filter shell and select only "IN"
if [Date]=today()or [Date] = today()-1 or [Date]=today()-7 then "IN" else "OUT" end
[Date_Header] // put this field in Column on top of Date
if [Date]=today() then "Today"
elseif [Date] = today()-1 then "yesterday"
elseif [Date]=today()-7 then "week ago"
multiple measures_rep.twbx 35.8 KB
Shin, that worked great. Clever use of the Data_Filtered field.
Great to hear that kind of feedback.
You saved time!!
Shin - any chance you have an idea about how to show increases / decreases of Today versus Yesterday / a week ago ?
I was thinking if variation is larger than 10%, than show a green / red arrow. I tried creating a calculated field named Increase_Profit like this:
IF (sum([Profit]) - LOOKUP(sum([Profit]),-1) ) / LOOKUP(sum([Profit]),-1) >= 0.1 THEN "▲" END
It kind of works, but it highlights the entire column, and I would like to only highlight the `Profit` cell.
Perhaps I should open a new thread on this.
multiple measures_rep.twbx 19.4 KB