Conditional totals

In the previous example, total was calculated for all data rows. We can limit this range by indicating the condition in the total editor. Total will be calculated for only those rows, whose condition returns true.

For example, we can set the following conditions:

This will mean that, total should be calculated for those products, whose Discontinued flag is not set.