主权项 |
1. A non-transitory computer-readable medium having instructions stored thereon that, when executed by a processor, cause the processor to transform input data into pivot table data, the transforming comprising:
receive the input data comprised of attributes as columns and data across the columns as rows, wherein the input data is received in a delimiter-separated value file format; receive locations for at least some of the attributes as zero-based edges, wherein layers of the edges are presented from the slowest to the fastest varying layers; receive a designation of data values that appear at intersections of edge attributes from the same row; receive aggregation instructions comprising a list of edge attributes and data value/aggregation type pairs; for each of the zero-based edges, create an edge tree; walk the input data by row, and, for each edge attribute, distribute the value of the edge attribute to the edge tree created for each zero-based edge location; store data for each row in a multiple edge attribute/value pair hash table, the hash table including a plurality of key/data value pairs representing intersections of edge attribute values with the data value to be displayed at each intersection, each key including a plurality of edge attribute values; in response to the aggregation instructions, create special total rows; walk the special total rows and place special edge attribute values before or after the value of the edge attribute on the tree; and display the data in a pivot table based on the edge tree and the hash table, the pivot table including a data body having a plurality of data value cells, a column edge, a row edge and a page edge having a pivot filter bar to filter the data displayed in the pivot table based on data not displayed in the pivot table. |