Pivot Table Not Recognizing Aggregated Query

I'm trying to make a pivot table to breakout orders by sku/month. I've gone ahead and made a query using the non-native editor, however it seems like the pivot table does not recognize that it is aggregated data. I'm not sure what would be preventing this from working and hoping that I'm missing something obvious.

DB: PostgreSQ
Metabase: v0.45.1

Please upgrade to 0.49.15 since you are in a very old version it could be possible there was a bug