5 Replies Latest reply on Dec 7, 2018 2:02 PM by Paul Wachtler

# Compare Results from Two Different Worksheets in Third Worksheet

The attached dashboard allows a user to compare two different car models to see which one has more american made content.

The user simply chooses the two car models to compare, and then views the results. Comparing two sheets is easy, and I can get a separate score for each model.

In the Results pane, I am trying to compare the overall scores, but since Results is a separate sheet, the two fields aggregate to the same level every time.

I imagine this is a simple solution, but nothing I've tried has worked. Please help me capture the overall scores and compare them accurately on the Results sheet. Thanks. • ###### 1. Re: Compare Results from Two Different Worksheets in Third Worksheet

Hi, Eric

without using two parameters for model selection, it is hard to combine these two results into the 3rd sheet.

ZZ

• ###### 2. Re: Compare Results from Two Different Worksheets in Third Worksheet

Hi Zhouyi,

Thanks for replying. I had trouble with that method before. Do you have an approach that would work for my data?

Eric

• ###### 3. Re: Compare Results from Two Different Worksheets in Third Worksheet

Hi Eric,

As Zhouyi suggested, I was able to solve this by using parameters.  I saw that you already had one parameter created off of your model field.  I duplicated this so you have two parameters (one for each car selection).  On both the car specs 1 and car specs 2 worksheets I created filters so that it only shows the car that equals the parameter selection.

I was then able to create this LOD calculation for determining the higher TDC value on the results pane:

IF

{fixed:sum(if [Model] = [Select Car Model 1] then [Total Domestic Content] end)}

>

{fixed:sum(if [Model] = [Select Car Model 2] then [Total Domestic Content] end)}

THEN "Car 1 has higher TDC."

ELSEIF

{fixed:sum(if [Model] = [Select Car Model 2] then [Total Domestic Content] end)} >

{fixed:sum(if [Model] = [Select Car Model 1] then [Total Domestic Content] end)}

THEN "Car 2 has higher TDC."

else "Both cars have the same TDC."

END

Here's what the results pane looks like now: The updated workbook is attached.

Best,

Paul

• ###### 4. Re: Compare Results from Two Different Worksheets in Third Worksheet

Hey Paul,

Thanks for the help.

Eric

• ###### 5. Re: Compare Results from Two Different Worksheets in Third Worksheet

Welcome Eric, happy to help!