Event Dime

Inventory Movement - Pivot - with Opening Balance

When:

June 14, 2026 · 5:20 AM

Where:

Metabase Discussion

Source:

Metabase Discussion

What you need to do is wrap the inventory change columns in SUM() and drop any unneeded static columns from the query so the pivot knows how to compute the data columns when the time grouping, etc., changes. I would start small and work your way up, trying to pivot a dozen columns doesn’t work well.