Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Get total in row using matrix

Hi all,   I have data as below     I want to have the table as below using matrix table with total breakdown is combined as sum.  But what I get when place column category,ani...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Guys, 

     

    I have found the answer. I made another table which group by the total breakeven by anmial;

     

    BREAKEVEN_TABLE = SUMMARIZE(animal_table, animal_table[animal], sum(animal_table[breakeven])).

    BREAKEVEN_TABLE connect to animal_table using animal as key.


    Thank you!

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Guys, 

 

I have found the answer. I made another table which group by the total breakeven by anmial;

 

BREAKEVEN_TABLE = SUMMARIZE(animal_table, animal_table[animal], sum(animal_table[breakeven])).

BREAKEVEN_TABLE connect to animal_table using animal as key.


Thank you!