Hi!
I am trying to create a daily bank deposit from 3 different departments. The daily cash totals to be deposited are the sum of the clerks for each day in each department.
I have created a power pivot to grab the daily totals by department, but I can't get the rows to total.
It sounds like as soon as you're in this sandbox that the normal pivot table options (Show grand totals for rows and add a calculated field) are unavailable.
Does anyone know how I could achieve this? Or even better, have all the department totals aggregated by day?
Although given my lack of skillz whichever is easier is likely preferred.
Sample attached.
Thanks in advance for any help!
Bookmarks