Hi,
I want to build a treetable and before starting I’d like to solve some questions:
The treetable will be grouped into several layers.
-
What’s the best data structure for treetable?
Flat-table or pivot-table? -
How to aggregate the different layers? Layer 1 must be the sum of all Layer 2 - Layer 2 must be the sum of all Layer 3…
-
Is there any drill-down and bottom-up aggregation for numeric data, when editing cells?
Thank’s