Drill down without Pivot Table

Hi,

I have a table with formulas that count data on another sheet. If I use a Pivot table, I can double click on the cell with the results and it will create a sheet showing me the rows that were counted. I need to do that without a pivot table.

Thanks in advance,

swjtx99
swjtx99Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
D PatelConnect With a Mentor D Patel, Software EngineerCommented:
Find the tutorial in attached PDF (using Powerview in Excel2013)
How-to-create-a-table-with-Power-Vie.pdf
0
 
D PatelD Patel, Software EngineerCommented:
In the "Data" Ribbon, there is section "Outline", it has a "Subtotal" button, select the table, and then click on "Subtotal", menu that pops ups will help you build in the "drill" capability to the table.
0
 
D PatelD Patel, Software EngineerCommented:
Excel powerview has this functionality, available in v2013
0
 
swjtx99Author Commented:
Hi Dhara,

I tinkered around with PowerView a little but will give this another shot and let you know.

Seems like a lot to go through though. I have a countifs formula that says I have 4 rows that match the countif criteria, Would just like to double click to see those 4 rows without having to create a powerview.

Thanks,

swjtx99
0
 
swjtx99Author Commented:
Hi Dhara,

Your suggestion does technically work so have to give you credit for the solution, however, I find I cannot use a powerview table because my process creates the sheet and therefore I would also have to create the powerview using VBA so is probably not feasible.

Thanks for your help!

swjtx99
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.