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?

[Anonymous]

column(2)-column(1)

[sunny_talwar]

You might be able to use ValueList here, have not tested but usually works with an Island table, but since you showed reluctance for script changes try this:

Pick(ValueList(1, 2), Opportunieties, 'Difference') -> as your dimension

Name

Expression should be something along these lines

Pick(ValueList(1, 2), 'However you would calculate the difference', YourCurrentExpression')

[petter]

It could be done in this way:

[robert_mika]

Thanks, Sunny.

Script changes can be an option

I added calcualted dimension but that does not bring any values

What I', missing here?

Do you have an example of  this methode?

[petter]

There is a typo in the expression for John... so the calculation is wrong. It should state John in both Sums of that expression - not mixing John and Mike...

[tresesco]

Is this your real case, i.e. - only two line items would be there in your table? I ask this because, I doubt the alternative approaches would be suggested be dynamic unless you go with script solution. And if you are okay with static solution, let know.

[tresesco · Accepted solution]

May be like attached

[sunny_talwar]

Another one by making changes to tresesco‌'s provided solution.

[sunny_talwar]

Seems like ValueList doesn't work. I added a sample by modifying tresesco's qvw. See if that one seems like a viable solution.

Best,

Sunny