We have data for sales and orders which we aggregate up to the week end for purposes of showing in a combined KPI table. We want users to intuitively click on the pivot table (columns are week end dates) for either sales or orders, and pull up the appropriate detail.
I’ve reviewed this topic but don’t understand how to expand it to our use case, where I want to click on sales for week end 11/22 and have it filter the detail table for sales from 11/16-11/22.
