Forum Discussion

Helper V

9 years ago

Solved

SUMMARIZE AMOUNT UNDER THE SAME NAME OF DIFFERENT ROWS

I WANT THE SUM OF AMOUNT UNDER A SAME . i.e. for four name i have only four record in new table with their sum of amount.

Helper V

9 years ago

Anonymous

I have to create the summary table beacause i have to compare the total amount of last year to this year.

So it necessary for creating that.

So if you help me out for doing that i will be pleased.

Anonymous

Not applicable

9 years ago

Here you go

Table = SUMMARIZE( '15-16','15-16'[SBU], "Summary", Sum('15-16'[Value]) )

Now plot the SBU and Summary