Dynamic summary Tables with Custom settings

Pivot tables with dynamic report generation based on established User settings for the structure of pivot tables:

1. The necessary arrays of source data (more than 100 columns) are automatically exported to the pivot table.
2. In User settings, the following are set/selected:
- Report structure (necessary columns from the source table),
- criteria, dimensions for forming pivot tables, reports.
3. The necessary Reports are automatically generated in the developed forms. At the same time, the report forms automatically acquire the appearance and structure chosen in the user settings.
4. A Constructor for dynamic charts has been implemented (the user selects the necessary indicators).
IN ADDITION - a system for checking errors/unmet conditions/unfilled cells in the source table according to specified error-checking criteria is provided by:
1. Generating a report listing errors for each group of conditions.
2. Automatic generation of color highlighting for errors/unmet conditions.

#Google sheets #API #Google Tables
#Financial model #Financial modeling #Accounting #Warehouse #Warehouse accounting #Estimate #Estimates #Calculator #Analytics
#Pivot #Pivot #Tables