Can you please explain..It is bit confusing
Sorry for the confusion. Maybe this will clear it up.
I want to be able to create a calculated field called Conversion that:
1. Divides the number of Event 1 dates (4) by the number of Signups (6). Call this Event 1 Conversion.
2. Divides the number of Event 2 dates (2) by the number of Event 2 dates (4). Call this Event 2 Conversion.
But I'd like to do these calculations by each Signup week.
Thank you Ankit. This works, but I'm wondering if there is a way without having to alter, or union, the data set.