Forum Discussion

thedocs's avatar
thedocs
Helper I
3 years ago

Add Total to Matrix

Hi all, I have below page and cant get the 2 totals added on the Matrix as shown below. You can see also where they have been added highlighted in Yellow on the Row. I have spent hours playing with ...
Need Help
thedocs's avatar
thedocs
Helper I
3 years ago

I have uploaded the report to below location, I need to add a total to the column 'FY 2022' which I have not been able to do. I have been able to add total to the column 2023. Note the 'FY 2022' needs to stay in the row column.

 

Lintels Sales Laptop Report Test Total.pbix

 

lbendlin's avatar
lbendlin
Super User
3 years ago

Thank you for the sample data. Are you expecting the FY23 table to expand dynamically with each month?  If yes then you will be mucn better off using two separate tables, one for each FY.

  • thedocs's avatar
    thedocs
    Helper I
    3 years ago

    Hi Ibendlin, I appreciate the help, no I just need a total added for 'FY 2022',