Hello,
I have created two tables - one with the data and one with the associated date table. I had my pivot table working correctly where I could count tickets by date. However, when I refreshed the linked table connection, the data will no longer group by the dates. It seems as if the dates and the table aren't connected anymore, but they still have the relationship....Any ideas as to why this would happen?
I have created two tables - one with the data and one with the associated date table. I had my pivot table working correctly where I could count tickets by date. However, when I refreshed the linked table connection, the data will no longer group by the dates. It seems as if the dates and the table aren't connected anymore, but they still have the relationship....Any ideas as to why this would happen?
