2 Replies Latest reply on Sep 21, 2013 1:24 AM by Sam Brown

    Use Actions to Query One Level Up

    Sam Brown

      In the attached tableau file I am trying to use actions in the Filtered Line Items | Line Amount > $30 to show the Invoice level summary in the Summary sheet.

       

      However, because the items are filtered, only 1 line from Invoice_ID 100 is shown.  When I click on that line (Line_ID 3) the summary sheet only shows that one line's summary values. 

       

      How can I tell the action to summarize ALL line items for the 100 Invoice_ID when line_ID 3 is clicked?