3 Replies Latest reply: Oct 11, 2011 3:59 AM by vivek.singh RSS

    Calculate % Change on Pivot Table

      I've got a flat-file structured set of data that shows a bunch of orders, the year the order was placed, and the product type. I've provided an example below. Simplified for sake of discussion.

       

      Order IDYearType
      342162008Red
      984322010Brown
      102932009Brown
      123452010Red
      678902009Yellow
      543212010Brown

       

      Here is the table I want QlikView to produce. I've been able to accomplish this with a Pivot table except for the % change. How would I go about calculating the % change? I'm looking for solutions that either include an expression or hopefully without the pivot table altogether. Using something other than the flatfile with one single year column is not an option. Thank you in advance for your thoughts!

      Type200820092010% Change
      Red1010%
      Brown012200%
      Yellow0100%