|hello guys, i am doing a project where i have to make more than 40 pivot tables, they asked my to resume all this pivot tables, what would be the best way to sumerize all this pivot tables. The structure is as follows each workbook represents a month so twelve workbooks, each workbook has 4 sheets and each sheet has 2 pivot tables. One pivot table consist of monthly payments for each worker(600+ workers) and the other pivot is the total cost per establishment(15 establishment).|
Is it possible to have one sheets where i can call up on the information like total for the 10 months or the total for a specific month, or total for one worker for the last 10 months.
thank you in advance