You have mentioned Pivot Facets, but have you looked at the Path Hierarchy Tokenizer Factory:
http://wiki.apache.org/solr/AnalyzersTokenizersTokenFilters#solr.PathHierarchyTokenizerFactory This matches your use case, as best as I understand it. Jason On May 28, 2013, at 12:47 PM, vibhoreng04 <vibhoren...@gmail.com> wrote: > Hi Erick and Markus, > > Any Idea on this ? can we resolve this by group by queries? > > > > -- > View this message in context: > http://lucene.472066.n3.nabble.com/Nested-Facets-and-distributed-shard-system-tp4065847p4066583.html > Sent from the Solr - User mailing list archive at Nabble.com.