Hi, Thanks for the suggestion, I'll investigate intersect-count, though I need to calculate other aggregates as well, such as averages.
Here's a more detailed example to elaborate. kylin-example.xlsx <http://apache-kylin.74782.x6.nabble.com/file/t1100/kylin-example.xlsx> Ali -- Sent from: http://apache-kylin.74782.x6.nabble.com/
