3 Replies Latest reply: Apr 17, 2013 8:34 AM by 1003660 RSS

    Pivot Table, Excel Template BI Publisher

    986763
      Helllo, I'm a BI Developer. I have this report that needs grouping for the output. To give a sense of what I need to do, I will give an example.

      Here is the data:

      Question 1 Easy
      Question 1 Hard
      Question 1 No answer
      Question 2 Easy
      Question 2 Hard
      Question 2 No answer

      The output of the report can't repeat Question 1, it needs to be grouped.

      Question 1 Easy
      Hard
      No answer

      Unfortunately, the data model is not designed at the question level, so I can't use XDO_GROUP?DATA_SET? Is there a way of making a sort of a pivot table that would apply to the output?

      Edited by: 983760 on Feb 1, 2013 8:14 AM