1 of 1 people found this helpful
It's always helpful to share data or a sample workbook. It sounds like you are headed in the right direction. You could try
- Creating a filter based on the parameters and your order dates. Add the filter to context so it will work on LODs.
- Creating a fixed LOD at the customer level counting the distinct Month/Years of your order date.
- Creating a calculated field dividing the LOD above by the date diff between the parameters.
- Create a filter where the above calculated field is >= .5
I have tried to create what I am looking for . Please have a look at the sheet. It has the start and end date parameters and the difference in months field. I am not sure in which direction should I Proceed now.
but this is the output I am expecting.
For each region just show me the count of customers who have reported more than 50% of time in this case more than 6 months for each region.
Sample.twbx 1.2 MB