1 Reply Latest reply on Jul 24, 2018 7:15 PM by swaroop.gantela

# Calculation to show % difference between two different measures

Hey All!

I am trying to find a way to calculate the % difference between two different measures agnostic of time. I don't have the ability to share a workbook.

Scenario:

I have different measures that compose a lead funnel. I have them organized by row so they appear like this:

Each of the above is an individual measure pill and I'm displaying them via Measure Names and Measure Values.

What I'm wondering is this - Is there a way to show the % of previous without having to manually calculate out each measure?

To clarify - What I want to do is to be able to show what percent one measure is of the measure above it, such that:

And so on in that fashion. So far I have been manually calculating fields for each measure, but I'm wondering if there is a quicker / more efficient way of doing this.

Thank you!

• ###### 1. Re: Calculation to show % difference between two different measures

Ryan,

There may be a way to simplify, but it may depend on the nature of your calculations to get each step.

Instead of calculating the count for step, could you instead make one Dimension Calculation to the effect of:

...

END

Then put that on the Row shelf and SUM(Number of Records) on the Column shelf.

Then you can right-click on SUM(Number of Records) and add a quick table calc

percent difference from previous.