i've got a calendar table with Date, day, week, month, year.
This calandar is connected to some fact tables.
If i select a year, a month and a day then automatically a weeknumber is returned.
For a report I want to get this weeknumber to calculate the WTD. But if I selected a week in the past, it should also show that weeks to date. So basically the week to date is based on the users selection.
But if you dont select the week itself, you cant use Getfieldselections. Is there another way to create the WTD.
I wanted to use set analysis for this, but i need the weeknumber.