Get total in row using matrix

[Anonymous]

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!

[Anonymous · Accepted solution]

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!

[amitchandak]

@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])