2 Replies Latest reply: Aug 10, 2011 2:31 AM by Mariliis K.-M. RSS

    Using dimensions in script

      Hi,

       

      I have list of stock transactions (table is below) and I'm trying to get Aged Stock report that would show me how many items from different period I have in my stock.

      When I create Pivot table to see item statuses I get table below. Now I should continue to get the table correct as item 101 result -30 for group <90 should belong to >90 instead. Is there option to get values presented in table to script already, so that I could use if statements when >90 is higher than zero, then sold units should be grouped to >90 instead.

       

      I believe it is not so difficult and I'm only making it more difficult to myself.

       

      Screen shot 2011-08-09 at 11.34.50 AM.png

      Any easier ideas and solutions?

       

      Thanks in advance!