O'Reilly logo

ADempiere 3.6 Cookbook by Ajit Kumar

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Slicing and dicing

The query, by default, returns a data set on which the analysis is carried out. During the analysis, if you want to limit the data set to a smaller set and base your analysis on top of it, then you can create a slice of the data and use it. This is achieved using the filters in JPivot. This recipe describes the steps required to define and apply a filter and how to remove it.

For the recipe, we have taken the use case where the user only wants to look at the sales and purchase details pertaining to a particular product—Patio Table.

How to do it...

  1. Click on the How to do it... toolbar button. The following section appears:
  2. Click on the icon ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required