I can't share the file due to security purposes. I need my pivot table to show these 4 calculations for months- April to Jan: Carried Forward, New, Completed, Pending (=carried forward-completed+new). The months obviously contain duplicate values, which need to be calculated for the next month. It's basically related to inventory. Please help.
Bookmarks