0 Replies Latest reply: Nov 2, 2011 2:46 AM by rob heinen RSS

    filtering

      Say I have a set of data that consists of a data field and an identifier field. There are much more distinct data than there are identifiers.. I would like to split this set in a pivot table into one field containing the identifiers and one field that contains the data. Furthermore I want the be able to open and collapse the identifier field, in order to show or hide the data as I please. How do I go about?

       

      Thanks in advance for your reply