Hey all,
I have done a relation to another sheet, and I am using the Lookup option to bring in a bunch of values that are listed for that particular Store ID.
Attached is the setup of the tables I have.
I also eventually want to break down the total created in that column into different columns with filtered data → So when I click a Store, I can see how many passes were consumed by customers and staff.
Is your lookup through a multiple relation?
If so, you can replace that with a rollup column to get a sum directly.
I don’t know what I would do without you on this platform. Thanks Darren!
What do I have to do if I want to showcase a filter on the SUM of the Total Passes… that is, what if the passes were attached to a category or type, how do I showcase that count of passes in a single category?
Replace your multiple relation column with a query column, then you can filter by category.
