Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello! I'm new to QV and I know just enough to be dangerous. 
We have a need for a drilldown on our dashboard, and I just can't seem to get it to work.
Detailed data is:
Product unit ID (i.e. 12345)
Product Description (i.e. Super Supreme Scooter Jr.)
Product Category (Scooters)
Product Category Status (Shipped)
Metric A (Something to measure)
Metric B (Something to measure)
I want to create a dashboard where I show the aggregated metrics, but also give the user the functionality to click on the aggregated metric cell and then be taken to a table that shows all the details for that particular dimension/metric.
In other words,
The aggregated metrics table would look like this. It is the first thing the users see, and we want them to be able to click on any SUM(METRIC X) column to be shown all the items relevant to that dimension/metric.
| Product Category | Product Category Status | Metric A | Metric B |
|---|---|---|---|
| Bikes | Manufacture Complete | 10 | 30 |
| Bikes | Prep for Shipment | 20 | 22 |
| Bikes | Shipped | 30 | 12 |
| Scooters | Manufacture Complete | 100 | 20 |
| Scooters | Prep for Shipment | 200 | 30 |
| Scooters | Shipped | 400 | 100 |
After a user clicks Metric A/ Bikes/Prep for Shipment I want them to see this:
| Product unit ID | Product Description | Product Category | Product Category Status | Metric A |
|---|---|---|---|---|
| 12345 | Big Bubba Bike | Bikes | Prep for Shipment | 1 |
| 23456 | Small Kid Bike | Bikes | Prep for Shipment | 1 |
| 23456 | Old Folks Bile | Bikes | Prep for Shipment | 1 |
| etc |
Any insights would be greatly appreciated!
