Create table with number of day names in a month

[Anonymous]

Hi All,

I need assistance in creating a table like below and have no idea on how to go about it.

Month	Total Sundays	Sundays Left	Total Mondays	Mondays Left	Total Tuesdays	Tuesdays Left
Jan	4	0	4	0	4	0
Feb	4	0	4	0	4	0
Mar	4	0	4	0	4	0
Apr	4	0	4	0	4	0
May	4	0	4	0	4	0
June	4	0	4	0	4	0
July	4	0	4	0	4	0
Aug	4	0	4	0	4	0
Sep	4	1	4	1	4	1
Oct	4	4	4	4	4	4
Nov	4	4	4	4	4	4
Dec	4	4	4	4	4	4

So basically, it is a table which says how many number of days each month has and how many are left.

Can this be achieved?

[marcus_sommer]

You could get such table just by using Month and Weekday as dimensions from a master-calendar: How to use - Master-Calendar and Date-Values within a pivot-chart and then using as expressions something like this:

count(Date) // totals

count({< Date = {">=$(=today())"}>} Date) // left regarding to today

- Marcus

[Anonymous]

Thanks,

So what I did was to generate a master calendar in the load script. I have the first and last day of the month. But could you give a script as to how to calculate a specific day between 2 dates.

Say I want to calculate the number of Sundays between 01/01/2017 and 01//31/2017, how do I do it?

Help is appreciated. Thanks

[marcus_sommer]

It was meant to use Month as vertically dimension and Weekday as horizontally dimension and than using just the above mentioned count-functions.

- Marcus