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

    Compare Results from Two Different Worksheets in Third Worksheet

    Eric Pastore

      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.

       

      Which Car is Made in America.png