Forum Discussion

Amitkr174's avatar
Amitkr174
Icon for Helper III rankHelper 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+",    ...
lukiz84's avatar
lukiz84
Icon for Memorable Member rankMemorable 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
Icon for Helper III rankHelper III
2 years ago

yes, you are right

  • lukiz84's avatar
    lukiz84
    Icon for Memorable Member rankMemorable Member
    2 years ago

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