1 Reply Latest reply on May 31, 2013 12:50 PM by Joshua Milligan

    How to Filter/Rank by Top Product Type then by Top Product for Each State using Sales?

    Jeff Campbell

      I am trying to find the Top Product Type in each state using Sales Dollars. Then once the Top Product Type for each State has been determined, I want to know the Top Product that goes with the Top Product Line for each State.  I have tried using different ranks, sorts, and filters, however I cannot get it to calculate the Top Product Line by each State.  It will only calculate the Overall Top Product Line, not at the State Level.

       

      I have attached the Sample-Coffee Chain with how I hope to have it laid out.  I would only like to see the Top Any help or advice will be appreciated.  Thanks!