• 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.

Excel Dashboard using DropDown Boxes

Vivek D said:
Haven't been checking Chandoo lately as I've been busy with work.

Use attached. If you are still having the date problems send me the file with the updated data.

I've added the Totals up top as I thought that would be better than having to scroll down to see the total. It was also easier to do so went that route :).
Click to expand...

Hi Vivek D...
I am wondering if you'd be able to help me with a new dashboard .. Just the formula part. I am using the same format as the Dash you helped me with before. I attached the new data with different headings.
The formula I am looking to get help with is on the Production Dashboard tab. The previous formula counted result codes. I am wondering if this formula can return what's in the AcctsData pivot table on the Working Sheet Tab?
I'd also like to add a few more slicers, but I can handle that part. I thank you for help in advance. As it is greatly appreciated.
Thank you so much!
 

Attachments

  • New Purchase Dash.xlsx
    89.3 KB · Views: 23
Does the Working sheet already show all of the data that you want to show as part of the dashboard? If so, we can just convert that into the Dashboard. No need for any formulas or a separate sheet.

I think I had added the working sheet previously because the final result was a combination of 2 different pivot tables. In this case it appears like you are able to get everything you need directly from a single pivot table.

Let me know.
 
Vivek D said:
Does the Working sheet already show all of the data that you want to show as part of the dashboard? If so, we can just convert that into the Dashboard. No need for any formulas or a separate sheet.

I think I had added the working sheet previously because the final result was a combination of 2 different pivot tables. In this case it appears like you are able to get everything you need directly from a single pivot table.

Let me know.
Click to expand...


Yes. The working sheet is everything I need. Some data is going to be added, but if I have a basis, I can add what I need. I think I just need assistance on the slicers then.
That would be great!

Thank you!
 
Adding slicers is very easy. Just check this tutorial or any others you come across if you do a google search on "Excel Slicers".

Just put your cursor on a cell within the Pivot table, go to Insert -> Slicer -> choose the fields you want slicers for. That's pretty much it.

Try it out and get back if you face any problems.
 
You must log in or register to reply here.
Back
Top