Impossible create table

[Anonymous]

Hi everyone, I need help
I have this table with this information

ID	INCOME	REVENUE	MONTH	YEAR
1	3500	1400	12	2019
2	3400	890	11	2019
3	2000	200	10	2019
4	3200	2500	12	2018
5	1000	100	11	2018

and I would like to be able to process this table

INDICATOR	DECEMBER 2019	NOVEMBER 2019	DECEMBER 2018	FINAL 2018	FINAL 2019	SLA (MEASURE)
INCOME	3500	3400	3200	48000	46000
REVENUE	1400	890	2500	2300	1441

I tried to use an array but to no avail

I would also like to add that the months can change and can even be more than one up to all. The final balance should be the sum of the whole year

best regards

[amitchandak]

@Anonymous , From Month Year you can create a date and give this format .

Month Year = format(date([year],[month],1),"MMMM-YYYY")

Use that on the column of the matrix. And use show on the row. That will move Measure on row. Switch it on

https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/

[Anonymous]

Thanks a lot @amitchandak .

How can I block the total? In the sense, if I don't want all the months of the year but only some and keep the total of all?

Thank you

[v-xuding-msft]

Hi @Anonymous ,

You could reference the gif to turn on and off subtotals.