Native Pivot Table Functionality

Idea created by krheinlander on Oct 27, 2015

    Although relational structures are efficient for data entry presentation, post entry database records are often best represented in reports and post-entry exports for analytics, in a flat file structure, where the relational hierarchy is represented in one record from the parent record basis.


    This can be accomplished today with a virtual list approach, a relatively complex bit of code for something that is an extremely common presentation requirement for users, as well as for data analytics.


    Alternatively, having to rely on Excel to do this work, is marginally OK for analytics, but not acceptable for in-program data representations and tabulated results.