ANALYSIS VIEW FOR PIVOT TABLE INTERFACING

摘要

Various methods, systems and storage devices are used for creating and utilizing an analysis view for pivot table interfacing. The analysis view can be created with a visualization that reflects data summarized in the pivot table automatically in response to detecting user input directed at a particular data field (i.e., cell) of the pivot table and without requiring any additional user input, such as user input required to navigate a chart wizard or any other graphics interface. The visualization includes at least one selectable and transient object that is configured for being selected and dragged out of the analysis view window and which persists even after the analysis view window is closed, unless it is first dragged outside of the boundaries of the analysis view window and without requiring additional user input for separately closing and/or removing the transient object.

主权项

1. A computing system comprising:
at least one processor; and at least one storage device having stored computer-executable instructions which, when executed by the at least one processor, implement a method comprising:
accessing a document containing a plurality of populated data fields;detecting user input directed at a particular data field of the plurality of populated data fields;determining that the particular data field comprises an aggregate value representing data from a plurality of separate data fields; andupon determining that the particular data field comprises the aggregate value, automatically generating a visualization that graphically reflects content from the plurality of separate data fields.