I am trying to create a view where I can see the following for the last 12 months
grouped by category groups (not categories).
Is there a simple way to do it?
So far, I have created a pivot table using Data-> Pivot Table and have added Accounts for rows and Months for columns and summed the values for the amount. But this is just me trialing and it’s no way near to what I want.
Any idea how to do it?