how to display the column total same as row data values

Question

We have data like below and need to disply the total same as like row data value..

data in PBI

expected output:

need to display amount total based on item id

And if we remove the name and value, the expected out put would be lik this

hotchilli · Answer

You can use an aggregation of MIN on the Amount.&nbsp;
What happens when there are different items in the table?

Forum Discussion