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
Bookmarks