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,animal & breakeven place at row; price sold as value using matrix as below;


anyone can help me with this?

Thanks!

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!

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous , I doubt you can get like first screenshot. But you can get 10 the same number first screenshot

     

    You can have a new column

    sumc(filter(Table, [Category] = earlier([Category]) && [animal] = earlier([animal]) ), Table[breakeven USD]) 

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