I have a table with payments. The table includes the payment provider, the processed payment amount, and the fees for that payment.
I want to create a pivot, showing the total processed amount, the total fees, and the overall fee percent for each provider by month.
But I keep getting errors. The results show when I first create the question, but then when I reopen the question or add it to a dashboard I get an error.