8 Replies Latest reply on Aug 12, 2013 5:26 AM by Jonathan Drummey

    Cannot get top 5 product sales by state

    Frank Maduri

      Hello,

       

      This should be an incredibly simple exercise, yet I have spent over 2 hours trying to resolve the problem with no luck.  I am trying to display the 5 best selling products in a specific state.  I can do this on a national basis and confirm the data.  My measurement is sum(sales) and my rows are top 5 product (a set I created).  I have a filter showing all states.  When I select Washington state, I am only getting the sum of sales for the top product sold.  There should be additional products based on importing the Excel data into ACCESS and running queries to confirm my results.  The data source is the demo file Sample Superstore Sales.  Any ideas?

       

      Thank you.

       

      Frank