use drop down with last wk to filter crosstab

[touwen_k]

I have a quesiton: in a drop-down list I have values as last wk, last 12 wks etc. I would like to select this value and based on that filter my crosstab table( I have a week value there). how to do it? regards Karolina T

[acordes · Accepted solution]

Create an item today as datepart(now())

Then add a slider as a filter, assign a parameter to it allowing for week shifts from 1 to 12.

then apply an advanced filter to your object, this resolves to true if the date variable is greater then the shifted date from today.

[touwen_k]

thank you very much for your answer. I will try it out. I am a beginner in VA. The request I 've got it to have a sum of sales for last week and sum of sales for last 12 weeks. The idea is to have one row in cross tab which shows the sum. Is this slider also showing that?