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 ...
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.
