Chayce, I will try again. Thanks for the feedback. With this table, I have a chart that shows turnover by FT, PT and PTR. So, three series. That part is easy. I would like a fourth series that is total turnover. To get that number, I have to average the total employee count and add the monthly turnover rate. I can see the correct numbers at the bottom of the table, but I can't figure out how to do the formula myself to make it show as another series in the same chart. (A stacked bar could work, but that's not really the best option here for a couple of reasons.) Using the total and everages options for the FT, PTR and PT, Total Employees in their field options gets me there in a table, but I need to show it in a chart.

I think I have to use some sort of Summary Formula or Variable, but the formula I thought would work isn't.

This pic is of my current chart. It is exactly what I want. I just need to add a fourth series that is total turnover rate. But, I don't have that as a specific field and not sure how to make it happen.

------------------------------

Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)

IT Director City of New Braunfels

------------------------------