6 Replies Latest reply: Oct 22, 2013 8:24 AM by Michael Solomovich RSS

    Calculation problem

      Hi everyone,

       

      I came across a quiet weird problem. I posted a picture so you should look at it I have a min Date to every product and I try to calculate now how many pieces I had in stock on the min date of my product. so the product 712486 I had in stock on the 05.06.2012 in stock the first time and I had 10 piece of it. so my second product 726751 I had in stock the first time on the 30.10.2012 so far so good but QV still calculates the pieces i had in stock for the 05.05.2012 but I want it for 30.10.2012. Can anyone help me to fix this pivot table??

       

      regards,

      MT