I have a Pivot Table that compares the monthly number of orders from last year to the monthly number of orders for this year (See Pivot Table.png).
The attachment Pivot Setup shows how I set the pivot table up.
What I would like to do is add Yearly Totals to the far right of the pivot table (See Desired Pivot Table.png). This would show the Total Number of Orders for last year as the Total Number of Orders for this year.
I have tried adding Totals to the Rows, Columns and Values but the only totals I am able to come up with is a combined total of both years.
Is there something I am missing, or can’t this be done in Acumatica?
Thanks you!
