Hi, how can I calculate the average cost of multiple lines based on if they have matching criteria and return/display that average cost on all 3 rows?

Question

Ok, I've uploaded my workbook as well as a snapshot of the formula I would use in Excel that I'm trying to replicate in Tableau. I am trying to calculate the average cost based on matching lines of Site, Product, and Part. Thanks!

Jim Dehner - Tableau Visionary HoF · Accepted Answer

agree with @James Emery​  would like to see your twbx - but before you do review  https://jimdehner.com/2022/09/06/calculating-averages-or-rates-how-to/   on calculating averages and rates Thanks Jim - Tableau Visionary

Jim Dehner - Tableau Visionary HoF · Answer

Glad to help out. If you don’t mind please mark my response Best to make it easier for others to find and to close the thread Thanks Jim - Tableau Visionary

Hi, how can I calculate the average cost of multiple lines based on if they have matching criteria and return/display that average cost on all 3 rows?

Tableau Desktop & Web Authoring

Related Learning

More Help