My company is brand new to Monday.com and LOVE it! So thank you for such an amazing product!
I’m trying to figure out how to display Totals for each Project Manager (PM) while also breaking down the totals for each Foreman for each PM. I’ve made a Formula column inside the original board however can’t find it inside the Pivot board.
I’ve also attached a picture that shows what my end goal is.
Side note, I’m trying to find a clean way to view each month along with the totals but I’m not sure this can work cleanly (besides in a graph.)
Here is what my goal is: