Difference between two values from same column

Question & Answer
, ,
1

Hello! I have one dataset containing PlanID, Month, Cost. I want to compare two plans, so showing PlanID_1’s cost, PlanID_2’s cost, and then the difference between the two. And I need to have a filter to pick which plans to compare. I don’t know how to approach it.
Thanks in advance!

2

Hi

for this you need to create two parameters and e.g criteria 1 and criteria 2 and then using countIf(Plan1, plan1 = ${Criteria1}) similarly for other cases.
In this way you can achieve your desired output.

1 Like
3

Hi @belengim,
It’s been awhile since we last heard from you, did you have any additional questions or were you able to find a work around for your solution?

If we do not hear back within the next 3 business days, I’ll go ahead and close out this topic.

Thank you!

4

Hi @belengim,
Since we haven’t heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, fee free to create a new topic in the community and link this discussion for relevant information that may be needed.

Thank you!