I have a datamodel with invoice line items (transaction lines) and then product, customers and dates for dimensions and other descriptors. I have a flag setting on customer saying he attended a particular meeting. He will have attended many meetings. I have a list of the meetings and which customers attended them on which dates. My situation is that I need to report on each meeting, which customers attended and then which products they purchased 90 days before and after each meeting, and then 180 days before and after each meeting and then 365 days before and after each meeting to show trends and to see what affect attending the meeting had on the customers. I'm fairly new to QV and don't really know how I should tackle this. Any thoughts would be appreciated.
