PCC Consolidate

Use Tabular PCC consolidate feature to automatically populate the PCC aggregated entity based on PCC cell and PCC core Tabular returns.

To begin:
1. click Consolidate > PCC Consolidation function in the ribbon.

2. The PCC Consolidation screen consist of 2 grids:

Return selection grid
This grid only shows all return with the same reference date and reference period type as the current return (ie annual to annual, quarterly to quarterly etc) . Select the return to be consolidated in this grid.
QRT selection grid
In this grid, choose which QRT in the current workbook should be consolidated into. By default all QRTs are included for consolidation, but user can filter the list by deselecting the checked box.
Then click run PCC consolidation button to proceed.

3. A confirmation message will show informing user that rows will be left but all static data will be lost.Click yes to continue.

4. Once the process is done, this message will be displayed.

The consolidated result varies depending on the type of QRT :
Static QRT – the value from the source workbook will be concatenated into the current return and formulas will be replaced with the new calculated value.
List QRT – the consolidation process adds the same number of rows from the source workbook into the current return and formulas like subtotals and interaction will not be replaced.