Difference of two rows

[robert_mika]

Is  the a way to add an additional row to a table/pivot table?

My challenge is to take difference between two rows

Example below:

I need to know the difference between B and A for Mike and John.

Is it possible to do that in a table with expression or only script level?

[robert_mika]

Hi tresesco,

Your solution works.But as you mentioned there will be more item in the table.

Is there any other approach in case I will have up to 20 or more names?

Can the pick/match pull names from a list instead of static entries?

So for each name create the same expression but change that for the difference?

Many Thanks

[robert_mika]

Just have seen that and testing...

[tresesco]

In my solution, pick(match.. is in fact picking the values from dimensions. But the challenge in this approach would come when the rows increase. That means, would you expect a difference row after every couple of rows? Or, how? A sample with at least two differences would help.

[robert_mika]

Thank you all for the input.

Tresesco/Sunny your combined effort has brought the final solutions.

Thanks.