3 Replies Latest reply: Nov 22, 2016 3:48 AM by Don Andress RSS

    Table / Pivot Table with permenent filter

    Don Andress

      Hi.

       

      Is there any way to create Table / Pivot Table with permanent filter?

       

      I have an Excel spreadsheet with lots of data

       

      NAMETYPEJANFEBMAR
      name1type1482488467
      name1type2231237216
      name1type306-15
      name2type11420-1
      name2type1141147126
      name2type1598604583
      name2type3239245224
      name2type306-15
      name3type2712-8
      name3type2865871850
      name3type2-84-79-99

       

      On the same slide I have multiple tables and charts using the same data.

       

      How do I add to the same slide a net Table / Pivot Table which would use the same data but which would only show "name3"?

      I'd like to input permanent filter only for this new Table / Pivot Table so it always showed only "name3" and its value.

      At the moment filtering any of the charts or tables limits all other in the same app.