10 Replies Latest reply: Nov 15, 2010 3:02 PM by sergio . RSS

    Pivot table variance Actuals vs Forecasted

      I am trying to create a difference between Actuals and Forcasted amounts in Qlikview. This is very easy to do in excel but I am trying to create this in a pivot table in QV. Basically each month we have actuals and forecast and we need to do a difference to see what the amount is between the two. Also ideally at the end we would like to see a total for actual and forecast and a total difference calculated. I have attached the ideal scenario. Any suggestions on how to make this work?

       

      error loading image