12 Replies Latest reply on Aug 25, 2016 10:42 PM by Kajal Chandani

    Dashboard Action - Filter based on selection

    Matt Aguire

      I feel I am missing something really obvious here.

       

      BrandOrder 1Order 2Order 3Order 4
      A1000345543111
      B400433555222
      C30056652333
      D175344278444

       

      My data set has the following schema

      UserID,Brand,Purchase Cycle.   The counts above are distinct counts of UserID. 

       

      I want to have a 2nd worksheet on this dashboard that is filtered based on the selection above.  In this case the 433.  The 433 represents 433 customers who purchased brand B on their 2nd order.

      I want my 2nd worksheet to then display a table like the above for only the 433 customers. 

       

      I've tried using the same data source, as well as making a copy hoping to apply a filter.  I'm somewhat new so please forgive me if this is obvious.

      I need to avoid a live dataset, so sending this back to refresh a stored proc is not an option.