0 Replies Latest reply: Jan 17, 2013 5:50 AM by they_eye2 RSS

    Table report

      Hello,

       

      I'm trying assess whether QV is appropriate for a major project without having laid eyes on it before last week.

      After reading through some documentation, I'm trying to put together my first analysis object, and failing miserably.

      Any advice would be greatly appreciated.

       

      The object I'm trying to put together is supposed to compare the product set and product values between the current state of things (Reality) and a set of simulations like so:

      comparisontable.jpg

      It has the Universe dimension across the top, the Product dimension down the side, and three expressions.

       

      I've put together a pivot table that looks nearly like this, however it has two fatal shortcomings:

      1. I need the user to be able to easily sort on any column they like (preferably by double clicking on the heading)
      2. I need the "reality" universe to exclude the two "change" expressions, since it doesn't make sense to display the change of reality versus itself

       

      As far as I can tell, pivot tables don't allow easy sorting, and straight tables don't allow dimensions across the top. If true, that means I'm in a pickle.

       

      Any advice?