Newbie :baby_chick: here!
I have a tab of event submissions and a separate tab tracking prize payouts. I am trying to create a pivot table where I can look at payouts in multiple ways (by event, month, quarter, etc.) For the most part, the table works great, except there is an ‘Empty’ row I can’t figure out how to fix. For example, in one view, column A has event names and subsequent columns are for each month (column B - Jan, column C - Feb, etc) and the cell values indicate total $$ paid.
I can’t for the life of me figure out how to link those ‘Empty’ ones to their proper events so they do not appear as Empty. The only difference I can see between the ones that show properly and those that don’t is an ‘Event’ field in the record that shows name of event (which looks to be linked to a calendar). The odd thing is that if I look at that calendar, I see the ‘missing’ event there, but for some reason it’s not showing up on the list for me to tag… Hope that sounds somewhat clear… Kind of hard to explain.