Hi All....at the moment I am using one QVD Datei with field week_year. I want to create two selections(drop down menu) for current week_year and current week_year-3. So i need to create KPIs for latest weekyear and Kpis for 3 weeks ago. It is important to say that KPIs should be changed after users selection.
Also I need to create the table where I need to show for example status_new for current week_year and status_old for 3 weeks ago. Again, when user selects in drop down menu another week to compare then the results should be shown for this period.
Basically i need two filters(Old week_year and new_week-year) where new week_year will be always bigger then old week_year and users can compare KPIs based on their selection.