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 summarize only one of the columns ("Förändring")
I can only find option to show Total for both columns or none of them.

 

 

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.

2 Replies

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