Help

Help with Pivot Tables

Topic Labels: Extensions
564 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Carlyn_Usher
4 - Data Explorer
4 - Data Explorer

Hey Community :wave:

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.

image

0 Replies 0