I am trying to create a pivot table such as below where i am able to show both the current month total and the previous month total as stand alone columns in the pivot table. The total would be the value of all the months added together on right hand side of the pivot. Currently i have the pivot set up dynamically so the user can switch between different years and months and the values will appear. Is it possible to add these two columns to a pivot table. I am working with a date field and a value field.
Goal:
![tomf122_0-1659514156910.png tomf122_0-1659514156910.png](https://community.qlik.com/t5/image/serverpage/image-id/85796iD59E80AD2DEF434A/image-size/medium?v=v2&px=400)
Current Attempt.
![tomf122_1-1659514325829.png tomf122_1-1659514325829.png](https://community.qlik.com/t5/image/serverpage/image-id/85797i7C7B9DCDC506E847/image-size/medium?v=v2&px=400)