Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
May be like attached
column(2)-column(1)
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')
It could be done in this way:
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?
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...
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.
May be like attached
Another one by making changes to tresesco's provided solution.
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