Forum Discussion

swe_sebastian's avatar
swe_sebastian
Regular Visitor
3 years ago

Show difference between first and last column in a matrix instead of sum

Hi

Need help of showing the difference between first and last column in a Matrix.
Also I want to sort the Matrix based on the difference (Ascending or Descending)

I havo no problem showing the sum, but I need to show the difference.

 

Need Help

2 Replies

  • AnkitKukreja's avatar
    AnkitKukreja
    Icon for Super User rankSuper User
    3 years ago

    Hi swe_sebastian 

     

    You can use a measure directly referencing those columns to create a calculation. Can you share the sample data so I can create a measure for this?

     

  • swe_sebastian's avatar
    swe_sebastian
    Regular Visitor
    3 years ago

    Hi AnkitKukreja 


    The table is named "Fakturarader"
    The Rows are named "Leverantör"
    The Columns are "FakturaÅrMånad"
    The Value  is "NettoSum"

    Not really sure what you mean by sharing "sample data". I have dragged the Matrix to the Desktop.

     

    And the Matrix you have in my original post.