0 Replies Latest reply: Aug 3, 2009 9:44 AM by rey-man RSS

    WTD based on selection of year, month and day

    rey-man

      Hi all,

       

      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.

      Any help is appreciated

       

      Tnx in advance,

      Rey-man