You can do this using dashboard actions
please find below screen shots
1. When we click on Category wise sales it will take us to next dashboard where it displays sub category wise sales for particular category
2. When we click on back button it will take us back to category wise sales dashboard
3. When we click on sub category wise sales it will take us to next dashboard where it displays customer wise sales for particular sub category
Actions.twbx 455.7 KB
Thanks! This is close but not exactly what I am looking for!
Think of it this way. In your Category Sales Dashboard. You would have a
button for each of the categories. So you could click on Furniture, Office
Supplies or Technology, and it would take you the Sub Category Dashboard
filtered for that particular category.
So in this example if you had a button to click for Furniture on the
Category Sales Dashboard it would take you to the Sub Category Dashboard
only showing you the Sub Categories for Furniture. (If you filter sheet 2
for Furniture, you will see that the sub categories for Furniture are
Bookcases, Chairs, Furnishings, and Tables.)
Secondly the Sub Category Sales Dashboard would have a forward and a back
button. However, these buttons would keep you on the Sub Category
Dashboard, and would allow you to go back and forth between the different
Categories. (Furniture, Office Supplies or Technology) So basically instead
of a filter or a dropdown filter (or in addition to a filter) you would use
the buttons to scroll between the sub categories.
On Mon, Oct 17, 2016 at 11:27 PM, praveen p <email@example.com>
Brook, please don't ping a list of people like this. We respond to posts as we can and if appropriate for what we do, for example, I deal predominantly with Server so I am of no help here at all.
Oh sorry about that. I just googled top people who answer questions on this forum, and all of your names popped up.
[Toby thanks for this. So glad I deleted my less polite response.]
Brook welcome to the forums! Posting a sample packaged workbook is the best way to get our attention. I personally browse the forums and try never to answer questions that aren't well explained and don't include the necessary information to provide an answer. Packaged workbook is my first clue that you're serious about getting help.
As Toby mentioned, a list of names just let's me off the hook -- I assume someone else will answer, and I move on to other questions.
Thanks Shawn, sorry about that. I appreciate the help.
On Wed, Oct 19, 2016 at 2:27 PM, Shawn Wallwork <