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.