A drilldown in a pivot table can be opened by clicking If you click on the result value in a cell in a report.
The advantage of this drilldown in the , a drill-down opens in a pivot representation:
This drill-down in form of a pivot mask is that has the advantage that one can individually select and sort the criteria can be selected and sorted in accordance with customer requirements so that the amount can be divided into subtotals to be displayed according to one's estimation in such a way that the amount breaks down into subtotals, which can then be processed handled individually.
Additional fields can be dragged and dropped into the drilldown drill-down view, subtotals can be displayed or further restrictions can be made.
If the deal number has been integrated as a criterion in the drill-down view, the filter rules of the report cell are marked green after clicking on a deal, to indicate that they apply to the deal.
The functions uses At the same time, the values for the rules are placed opposite the value for the deal.
Based on a value in a report to describe , this describes the proof used to allow the deals and their respective shares to be why which deals with which share have been included in the amount.
It is also possible to conduct this process vice versa. FlexFinance also provides a solution, The drillup can be used on a certain deal basis, to identify the reports in which a certain reports the deal has been included , or not included, and to discover the reason for its exclusion.
Firstly, the user has to search for the deal in the object search, then open the deal in the overview page and click on ‘Reports’. Here, the user can see all the reports, their latest versions and information on whether or not the deal was included.
If one of these reports is opened, the user can click in each cell (on each amount) and see why the deal was included in this amount (according to which rules) or why it was not included in this amount (what rule was not complied with, resulting in the exclusion of the deal).