having multiple month columns - count different type of work orders by month

[Anonymous]

Hi, 

I am trying to build a report and I struggle with counting the work orders on a month by month basis in a single Table Visualisation because each type of work has a different month column depending on it's status and source of work.

The result I want to achieve is below. 

	January	February	March	April	May	June	July
Programme Works (Source of Work = Programme , PROGRAMME Planned Month for completion)			6
Programme Works Adhoc (Source of Work = Programme Adhoc , Planned Month for completion)		1
Completed Programme Works (Source of Work = Programme Adhoc + Programme , Status = Completed, Actual Completion Date)		1	1
Forecast Works (Status = Scheduled, Planned Month for completion)			4	2

Data source:

Source of Work	PROGRAMME Planned month for work to start	PROGRAMME Planned Month for completion	Planned month for work to start	Planned Month for completion	Status of Proposed work	Actual Start Date	Actual Completion Date
Programme	March	March	April	April	Scheduled
Programme	March	March	March	March	Scheduled
Programme	March	March	March	March	Scheduled
Programme	March	March	April	April	Scheduled
Programme	March	March	March	March	Scheduled
Programme	March	March	March	March	Completed	01/03/2021	15/03/2021
Programme Adhoc			February	February	Completed	15/02/2021	18/02/2021
Adhoc			February	February	Completed	25/02/2021	26/02/2021
Adhoc			February	Mar	Completed	16/03/2021	16/03/2021
Adhoc			February	Mar	Completed	15/03/2021	15/03/2021
Adhoc			February	February	Completed	16/02/2021	19/02/2021

How could I do this in a single table visualisation?

Thank you

[lbendlin · Accepted solution]

Those will all have to be separate measures.  In a matrix visual you can change the value display to "Show on rows"

So - create your measures, add all of them to the values well, then select "show on rows".

[Anonymous]

Thank you