Forum Discussion

Amitkr174's avatar
Amitkr174
Helper III
2 years ago

Column Subtotal not working

Hi, I have created a Deal_Band Calculated Column, which I am putting it in a Matrix table, but the total is getting repeated. New_Deal_Band = IF('DRID-SolutionMapping'[Net_ASV]>5000000,"5M+",    ...
Amitkr174's avatar
Amitkr174
Helper III
2 years ago

so how i solve this issue. Please advise.

lukiz84's avatar
lukiz84
Memorable Member
2 years ago

not so easy... because for each Entry in "Top Accounts" you can have MULTIPLE (1:m) values for New_Deal_Band

 

I don't think that's what you want... ?

  • Amitkr174's avatar
    Amitkr174
    Helper III
    2 years ago

    yes, you are right

    • lukiz84's avatar
      lukiz84
      Memorable Member
      2 years ago

      so then you first have to change your datamodel - what do you want to achieve?