4 Replies Latest reply: Mar 4, 2014 4:56 AM by neetha P RSS

    How to filter the data inside pivot table?

      Hi Community,

               I am using Pivot table chart to show the summarized data of infection data. However, there are huge number of cells, rows and columns are empty - there are no data. Is there any way I can filter out these empty rows or columns? I just want to show the rows or columns with data. One step further, is this possible to filter out the rows and colums whose maximum data in the cells is equal to a given number? For example, I only want to show the rows or columns whose maximum number (count of records) is equal to 5?

       

      Thanks

       

      Longmatch