• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Filter

K

kme

Member
Here Attached Ageing Report Summary
Required Answer In Second Sheet "Answer" Also Given Additional 2 Sheet Sample Answer Sheet

2nd Sheet B8 and C8 Drop down list Given
One is Branch and Second One is Status

Answer Data Came based on The 2 Drop down
If you we select Branch from the 1ST Drop Down and select Status "Running" from the 2ND Drop Down. then Only Concerned Data Came example "Sample Answer-2"

Required Formula In Second Sheet "Answer"
 

Attachments

Summary-sheet with slicers
Your writing do not give clear image about Your 'Sample Answer-2'-sheet

Please, before Your next posting
reread again

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...
chandoo.org
especially How to get the Best Results at Chandoo.org
 

Attachments

Sir Thanks for Your Replay. .

Here Attached Modified File Kindly Can We Solve through formula

1.Sir Can We Solve through Drop down Provided Answer Sheet B8 & C8

2.Answer Sheet Given 2 Drop down One is "Branch" another One is "Status"

3.If Select "Total" From Branch Drop Down List Status also "Total" Answer Came Like Reference Sheet # "Sample Q & Answer-1"

4.if Select Drop down Branch "Total" Status "Running" Then Answer Will be Came Like Reference Sheet # "Sample Q & Answer-2". If Hyper Select Then Came All Hyper's as per the first Drop down

5.if Select Drop down Branch Select "IOA" Status "Running" Then Answer Will be Came Like Reference Sheet # "Sample Q & Answer-3"
only "IOA" Branch have Brand Wise Receivable . Inserted a New Column Only for Brand for easy look up

6.if Select Drop down Branch Select "IOA" Status "Total" Then Answer Will be Came Like Reference Sheet # "Sample Q & Answer-4"

7.if Select Drop down Branch Select "LARG" Status "Hyper" Then Answer Will be Came Like Reference Sheet # "Sample Q & Answer-5"
 

Attachments

Do You have ... an idea that Your data supports any of Your ... answers?
With slicers it's like using filter, which You have asked.
Of course, I could add there one formula, but it won't be used anywhere.
 
You must log in or register to reply here.
Back
Top