
Good Morning,
I have a calculated field which divides #Records/Trays. The view is filtered by Location. When I drill down to Location, each individual location rate is correct. However, when I pan out to include all Locations, tableau is adding up each rate by location, rather than calculating a rate for all locations combined.
Any tips would be appreciated!