Patent ID: 11886462
Assignee: MICROSOFT TECHNOLOGY LICENSING, LLC
Field: Computer technology (Electrical engineering)
Classification: CPC G | IPC G

Claim 15:
16. A system comprising:
a memory for storing executable program code; and
a processor, functionally coupled to the memory, the processor being responsive to computer-executable instructions contained in the program code and operative to:
receive an indication to generate a pivot table from an existing table in a software application or service;
determine a plurality of fields included in the existing table to populate the pivot table with;
arrange, in memory, the plurality of fields in a first order;
arrange an order of the plurality of fields from the first order to a semantic hierarchical order based on a set of cardinality relationship rules;
identify a plurality of blocks included in the plurality of fields in the semantic hierarchical order;
generate the pivot table with the plurality of fields, wherein the generating comprises:
populating columns in the pivot table from fields included in a block of the plurality of blocks that has a cardinality value less than a threshold cardinality value, and
populating rows in the pivot table from fields included in one or more blocks of the plurality of blocks that have a cardinality value that meets or exceeds the threshold cardinality value; and

render the pivot table in the software application or service.