I am trying to count data into groups where the groups are a dimension. Suppose the groups are 1, 2, 3-5, 6-10 and I am counting apples. I am counting over different Selection Criteria (eg. start and end date of purchase) so sometimes the total count will fall into Group 1, sometimes into Group 2, sometimes into Group 3-5 etc.
There are also additional dimensions so that even if the period is fixed,a different dimension can cause different results. A dimension of 'Apple Type' (ie Granny Smith, Golden Delicious) would cause a different split than say, 'Country Of Origin'. I was wondering whether an Extended IntervalMatch would work here but I am not sure how this works. I think IntervalMatch is more script related and I am looking for something more document related.
Any help or direction would be really appreciated.
