How to show a column for Actual Totals and Budget totals

[Aspiring_Developer]

Hi Team,

I want to show the below output in pivot:-

Object ID| Apr|May|Jun|Jul|Aug|Sep|Oct|Nov|Dec|Jan|Feb|Mar|Actuals(Total-Sum of all months)

PR00001| 10|20|30|40|50|60|70|80|90|100|110|200|860

Similarly i want to show for budget.

Please find attached the screenshot of the output for the same:-

Can anyone please help ?

Thanks

[jochem_zw]

just use the month as a dimension, and set show totals to 'ON'

For sorting the calendar, think you have to use a fiscal calendar, see here:

https://community.qlik.com/t5/QlikView-Documents/Fiscal-and-Standard-Calendar-generation/ta-p/148082...