AnsweredAssumed Answered

Pivot Table Issues

Question asked by Steppyb on Aug 12, 2018
Latest reply on Aug 13, 2018 by Steppyb

Having trouble with a pivot table.

Here's what I'm trying to do: I have episode at the top and dates on the side. I have created a table that combines the date serial and episode serial numbers. There is a field that table (Episodes_to_Dates) called Cut that I want to use to go into the field that in the screen grab says 1-1.

What I'm thinking I need is a lookup field that looks at the Ep_ID and Date Serial and shows the appropriate cut field. But I'm not terribly sure what I'm missing.

Outcomes