Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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: