Forum Discussion
Impossible create table
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
3 Replies
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/
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
Hi Anonymous ,
You could reference the gif to turn on and off subtotals.
