1 Reply Latest reply on Aug 15, 2016 6:39 AM by Andrew Watson

    How to display number and total quantity of filtered selections

    kaptan cagri

      Dear all,

       

      I have a very basic query however not sure if Tableau is capable of doing this:

      FruitsQuantity (Kg)Imported/Exported
      Apple100Imported
      Banana200Exported
      Pine Apple200Exported
      Cherries50Imported
      Strawberries60Imported

       

      If I put this list on a Dashboard and set a filter Imported/Exported, how do I display the number of matching items? For instance for this table, if I click imported, I should see "3 items selected." (These are apple, cherries, strawberries.) somewhere on a dashboard. Can anyone help me in this?

       

      My second query is if I click on the filter Exported only, then is there any way to calculate and display aggregate amount of all Exported items? (400 KG for this example.)

       

      Kind regards