Skip to Content
0

Simple filter to display historical data.

Jan 09, 2017 at 02:48 PM

21

avatar image

I have a report that displays sales based on the week number.

My report is set to go out on Monday afternoon and needs to show sales for all previous weeks. The report is built to show the week number and in column 2 the total sales.

I have a specific "last week" report that I also send out on Mondays and it uses the following filter to ensure I am only capturing the previous weeks sales:

=Week(RelativeDate(LastDayOfWeek(CurrentDate());-7))

In my other report I need to show all sales of previous weeks.

Currently it is showing the sales for today (Monday) of this week. The requirement is to show all the previous weeks.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

AMIT KUMAR
Jan 09, 2017 at 03:00 PM
0

try this for previous week data.

Var=if([your week variable]=Week(CurrentDate())-1) then 1 else 0

Apply filter on the table where equal to 1 to get the previous week data only.

Share
10 |10000 characters needed characters left characters exceeded
Travis Reynolds Jan 09, 2017 at 03:23 PM
0

Amit,

Thanks for the reply, I failed to mention that I have all of the weeks listed, see screenshot below (please disregard years in header)and when I apply your filter, it filters all the other data as well. I am counting the quotes using:

=Count([QUOTES].[Quote Number])

How can I create a variable using a mix of both of these formulas so it only accomplishes what I need?


quotes.png (7.6 kB)
Show 1 Share
10 |10000 characters needed characters left characters exceeded

if you want to show the previous week data only in the column then use where clause.

=Count([QUOTES].[Quote Number]) where ([your week variable]=Week(CurrentDate())-1)

1