Week Number of the Quarter.1) Create a calculation to get the Week Numbers,
2) Create another calculation to get the serial No,
3) Add the Index() to the work area, then convert to Discrete.
4) Right click on "Index()", then define the Addressing, Partitions accordingly.
Now we get the Required Week Numbers, Week numbers are restarting at Quarter Level.
Then create another Report with Year, Month, Week Number, Week Day.
Then add the above 2 reports in the Dashboard, then define the ACTION from 1st Report to 2nd (Above line) report.
Thanks kumar! I already have wkofqtr number. My issue is how to nest the date under wknum hierarchy and make it continuous.