Count of Columns with Varying Sums

[Anonymous]

Is it possible with the same list of row values (projects), in a matrix, to calculate the sum of the column (# of projects) on a varying column such as month. Example below: 

Project	Sept	# of projects	Oct	# of projects	Nov	# of projects
Project A	1.1	1	2	1	2	1
Project B	4	1	4	1	1	1
Project C	2	1	1	1	0	0
Project D	3	1	0	0	4.1	1
Project E	1	1	1	1	0	0
Project F	5	1	3	1	0	0
Total	16.1	6	11	5	7.1	3

[wdx223_Daniel · Accepted solution]

create a date table and create a relationship between datetable[date] and facttable[date]

create a matrix, put the facttable[project] on the row and datetable[month] on the column, and the measure of sum(facttable[value]) on the value field.