I have two tables holding data for dates that i need calculating (Table 1 = Incoming) & (Table 2 = Started).
I created a pivot which gives me the number of people who are 'incoming' and another pivot table to show the number of people who have 'started'. I then clicked on the totals for both pivots (Incoming = 4291 & Started = 1321) which then created 2 new tabs for the totals. I needed to know the following through a formula;
- Count if the incoming date from Table1 (Incoming Date) is before the Incoming date of Table 2 and if so, check to see that the Started date from Table 2 is greater than or equal to 28 days from the Incoming date of Table 1.
There are 5 row labels i have split the total of 4291 into which for privacy purposes will say it as; Label 1, Label 2, Label 3, Label 4 & Label 5. So essentially would need to know the count for each label if selected out of the 4291.
