Drill down Budget

%3CLINGO-SUB%20id%3D%22lingo-sub-1529575%22%20slang%3D%22en-US%22%3EDrill%20down%20Budget%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1529575%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20looking%20into%20creating%20a%20drill%20down%20budget%20but%20I%20can't%20find%20the%20info%20I'm%20looking%20for.%20I%20want%20to%20be%20able%20to%20double-click%20an%20item%20on%20the%20first%20sheet%20and%20have%20it%20take%20me%20to%20another%20sheet%20to%20see%20the%20full%20break%20down%20of%20the%20item.%3C%2FP%3E%3CP%3E(i.e.%20click%20on%20the%20crew%20tab%20on%20the%20first%20sheet%20and%20have%20it%20take%20me%20to%20the%20second%20sheet%20detailing%20how%20much%20positions%20are%20getting%20paid%20in%20the%20budget.%20Then%20look%20at%20the%20first%20sheet%20to%20see%20a%20total%20sum%20to%20make%20it%20match%20the%20budget.)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20done%20this%20before%20with%20a%20specific%20budgeting%20software%20for%20a%20movie%20but%20I%20want%20to%20be%20able%20to%20create%20my%20own%20so%20I%20can%20customize%20it%20more%20based%20on%20the%20company.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1529575%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1529620%22%20slang%3D%22en-US%22%3EBetreff%3A%20Drill%20down%20Budget%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1529620%22%20slang%3D%22en-US%22%3EMaybe%20these%20instructions%20will%20help%20you%2C%20if%20not%20please%20ignore%20them%2C%20if%20so%2C%20a%20small%20feedback%20with%20thumbs%20up%20would%20be%20good.%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fde-de%2Foffice%2Fausf%25C3%25BChren-von-drilldowns-oder-drillups-f%25C3%25BCr-pivottable-daten-c1b11240-fc8f-4fdd-a697-629bf6f7ee0b%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fde-de%2Foffice%2Fausf%25C3%25BChren-von-drilldowns-oder-drillups-f%25C3%25BCr-pivottable-daten-c1b11240-fc8f-4fdd-a697-629bf6f7ee0b%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EI%20would%20be%20happy%20to%20find%20out%20if%20I%20could%20help.%3CBR%20%2F%3E%3CBR%20%2F%3ENikolino%3CBR%20%2F%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FLINGO-BODY%3E
Occasional Visitor

I'm looking into creating a drill down budget but I can't find the info I'm looking for. I want to be able to double-click an item on the first sheet and have it take me to another sheet to see the full break down of the item.

(i.e. click on the crew tab on the first sheet and have it take me to the second sheet detailing how much positions are getting paid in the budget. Then look at the first sheet to see a total sum to make it match the budget.)

 

I've done this before with a specific budgeting software for a movie but I want to be able to create my own so I can customize it more based on the company.

1 Reply
Maybe these instructions will help you, if not please ignore them, if so, a small feedback with thumbs up would be good.

https://support.microsoft.com/de-de/office/ausf%C3%BChren-von-drilldowns-oder-drillups-f%C3%BCr-pivo...

I would be happy to find out if I could help.

Nikolino
I know I don't know anything (Socrates)