topic Re: use drop down with last wk to filter crosstab in SAS Visual Analytics

use drop down with last wk to filter crosstab

touwen_k — Wed, 22 Sep 2021 16:24:36 GMT

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

Re: use drop down with last wk to filter crosstab

acordes — Wed, 22 Sep 2021 22:39:12 GMT

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.

Re: use drop down with last wk to filter crosstab

touwen_k — Fri, 24 Sep 2021 08:16:45 GMT

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?