Hi all, I’m having a hard time finding an answer to something that seems like it should be easy, but I can’t quite figure it out and other examples don’t fit my use case very nicely. I tried making sense of dynamic filters, but it wasn’t doing what I needed it to. I’m working on an advertising sheet across multiple vendors, categories, months, and stores. In essence, we have one tab in our sheet where all of our bills get dumped. It has the vendor name, amount, and single-selects for month, store code, and category. I’m creating a linked database that creates a pivot table of all of the vendors as the rows and columns for each month of the year, using rollups to calculate how much we spent with each vendor each month. Sounds simple. However, I’m running into issues with trying to filter the table by store. Many stores utilize the same vendors, so when I try to filter by store code, it’s totaling all of the bills per month for each vend
