Hello,
I have a Power Pivot which displays monthly budget per project.
I am using months & years slicers to filter the data.
The Budget column displays total Budget for selected months & years per project.
I need to add total yearly budget column which will display in each row the total budget for selected years (will not refer to months filters).
How can I do it?
I thought to add calculated field (something like sumifs) that will calculated the yearly data based on budget sheet/table.
But I do know how to define such calculated field.
I added a sample workbook - I need to add the yellow column to the pivot using calculated fields or other way. How can I do it ?
Thank you for your help
Bookmarks