2 Replies Latest reply on Mar 30, 2016 8:48 AM by Cory Vogan

# Using Parameters to compare differences between measures of dimensions

So, here's the situation. I am working on creating a worksheet that uses parameters to define two values of a dimension so that I can compare a measure between the two values. In this case the dimension is Provider which contains the name of restaurant chains (eg. Burger King, Denny's, CiCi's Pizza, etc.). Take a look:

As you can see above, to get to this point I have two Parameters (Provider A & Provider B). I have a calculated dimension using the following formula set up as a filter and a table calculation to identify the differences between the two providers with ColA as the baseline and ColB showing the %delta:

This is the most simple solution I was able to find to get here, but I was hoping to take it one step further. I would like to be able to have Provider A always display as the baseline in ColA and Provider B always show up in ColB for the %Delta. Is this possible? I understand that the reason it is working as it is now is because I am basically using parameters as selectors to check and un-check the filter box, and filters just display the columns in default order (alphabetically in this case). Any advice would be appreciated. Thanks!

• ###### 1. Re: Using Parameters to compare differences between measures of dimensions

i think i've founded a solution:

Measures:

Provider1V: It's values for Provider1

The idea is to create 2 marks:

The first one, only to show Provider1's values

And the second one to calculate the %delta:

ProviderDelta to filter 2 parameters

then

Configure the %delta table calculation by ProviderDelta and the option "Relativo a" - Relative to in english maybe as Provider1, So the calculation is always done over Provider1, You'll need to do that twice (marks and column)

• ###### 2. Re: Using Parameters to compare differences between measures of dimensions

I am going to try this and post an update with how this goes later today. Thanks!