Data Model Pivot to calculate frequency of visits for multiple dates and multiple clients

Hi Everyone,

I have attached a sample worksheet which shows two separate tables with a relationship and the resulting pivot table. I am specifically looking at dosage of both frequency of visits and length of visits. For length, I was able to calculate it in the pivot table easily and compare with between actual and recommended. For frequency, I am having a harder time understanding how to generate a column which subtracts each date from the previous one to show number of days between visits and the average # of days for each client.

I need to be able to analyze the data together so it would be great if I could have it within the pivot table rather than having to create a work around column. Any help would be appreciated!


L