Imagine that in our store we have products divided into categories. In addition to that, we store information about the stock of the items. Now, we want to show our crew how many of the products in the categories are in stock and how many we are missing. The first thing that comes to mind is using the faceting mechanism and some additional calculation. But why bother, when Solr 4.0 can do that calculation for us with the use of so called pivot faceting. This recipe will show you how to use it.
The following steps illustrate the use of pivot faceting:
schema.xmlfile in the field definition section; we will use the