Forum Discussion

swe_sebastian's avatar
swe_sebastian
Regular Visitor
4 years ago
Solved

Only sum one column in Matrix

I have a table for accounting. I would like to have a Matrix that only sums one of ny two values In the matrix I have two columns ("Förändring" & "Utgående") per months and I would likle to summari...
Need Help
  • swe_sebastian's avatar
    swe_sebastian
    4 years ago

    Thanks!

    I have unfortunately been to busy to look into this solution. It will probably work, but now the management has new requests so I will have to start all over again...
    I think I will have to rethink and create a new table with the information I need.

amitchandak's avatar
amitchandak
Super User
4 years ago

swe_sebastian , You can make grand total blank using isfiltered ([Year]), But if you create a calculation group, that will give better results with isfiltered and selectedmeasure

swe_sebastian's avatar
swe_sebastian
Regular Visitor
4 years ago

Thanks!

I have unfortunately been to busy to look into this solution. It will probably work, but now the management has new requests so I will have to start all over again...
I think I will have to rethink and create a new table with the information I need.