Conditional totals

Top  Previous  Next

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:

 

conditionalTotal

 

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