Perspective data table processing method and device

Abstract

The invention discloses a data perspective table processing method and device. The method comprises the following steps: summarizing and displaying to-be-displayed data in a data perspective table according to a plurality of dimension fields; classifying the to-be-displayed data according to data contents to obtain a plurality of dimension fields; the display area of the data perspective table is divided into a row field, a column field, a screening field and a data field; the data field is used for displaying the value of the dimension field and statistical summary; when an adjustment instruction of a user for any dimension field is monitored, displaying a data perspective table adjustment result in real time according to the adjustment instruction; the adjustment instruction is used for carrying out interactive data operations such as dragging, sorting and screening on a data perspective table; the method can be realized only through a front end. The perspective table adjustment result can be displayed in real time according to adjustment of a user, the operation complexity is reduced, the user experience is improved, and the data analysis efficiency is improved.

Description

Technical Field

[0001] The present invention relates to the field of computer technology, and in particular, to a method and device for processing pivot tables. Background Art

[0002] This section aims to provide background or context for the embodiments of the present invention described in the claims. The description herein is not admitted to be prior art merely by including it in this section.

[0003] A pivot table is a tool widely used in data analysis, which can quickly summarize and analyze a large amount of data. When a user analyzes data, it is necessary to dynamically adjust the data range or summary dimension according to the data situation.

[0004] For a pivot table with a fixed form, after the user configures the layout of the pivot table according to their own needs, the structure of the pivot table remains unchanged. If the user wants to adjust the report form according to the actual situation, they need to submit a new change configuration for development, which cannot meet the user's need for flexible data analysis.

[0005] For reports of visual data analysis tools, users can customize the report form, but they need to configure the report template first. After the template configuration is completed, the report can be rendered according to the template to display the data.

[0006] In summary, in the prior art, it is necessary to save the pivot table template first, then load the data and display it. The user needs to configure, submit the configuration, and then view the pivot table result, which will result in multiple template adjustments and then data loading, with cumbersome operations, poor user experience, and low data analysis efficiency. Summary of the Invention

[0007] Embodiments of the present invention provide a method for processing pivot tables, which is used to avoid pre-configuring templates, realize real-time display of the adjusted results of pivot tables according to user adjustments, reduce operation complexity, improve user experience, and improve data analysis efficiency. This method is implemented through the front end and includes:

[0008] Summarize and display the data to be displayed in the pivot table according to multiple dimension fields; the data to be displayed is classified according to the data content to obtain multiple dimension fields; the display area of the pivot table is divided into row fields, column fields, filter fields, and data fields; the data fields are used to display the values of the dimension fields and statistical summaries.

[0009] When a user adjustment instruction for any dimension field is detected, display the adjusted result of the pivot table in real time according to the adjustment instruction; the adjustment instruction is used to perform interactive data operations on the pivot table, and the adjustment instruction includes: dragging a dimension field to any position in any display area of the pivot table.

[0010] An embodiment of the present invention further provides a pivot table processing device, which is used to avoid pre-configuring templates, realize real-time display of pivot table adjustment results according to user adjustments, reduce operation complexity, improve user experience, and improve data analysis efficiency. This device is implemented through the front end and includes:

[0011] An initialization display module, configured to summarize and display the data to be displayed in a pivot table according to multiple dimension fields; the data to be displayed is classified by data content to obtain multiple dimension fields; the display area of the pivot table is divided into row fields, column fields, filter fields, and data fields; the data field is used to display the values of the dimension fields and statistical summaries;

[0012] An interaction adjustment module, configured to, when detecting an adjustment instruction of the user for any dimension field, display the pivot table adjustment result in real time according to the adjustment instruction; the adjustment instruction is used to perform interactive data operations on the pivot table, and the adjustment instruction includes: dragging a dimension field to any position in any display area of the pivot table.

[0013] An embodiment of the present invention further provides a computer device, including a memory, a processor, and a computer program stored on the memory and executable on the processor. When the processor executes the computer program, the above-mentioned pivot table processing method is implemented.

[0014] An embodiment of the present invention further provides a computer-readable storage medium, which stores a computer program. When the computer program is executed by a processor, the above-mentioned pivot table processing method is implemented.

[0015] An embodiment of the present invention further provides a computer program product, which includes a computer program. When the computer program is executed by a processor, the above-mentioned pivot table processing method is implemented.

[0016] In an embodiment of the present invention, first, the data to be displayed is summarized and displayed in a pivot table according to multiple dimension fields. When detecting an adjustment instruction for interactive data operations of the user on any dimension field, the pivot table adjustment result is displayed in real time according to the adjustment instruction. There is no need to pre-configure a template, and the pivot table adjustment result can be displayed in real time according to the user's adjustment, reducing the user operation steps and complexity, improving the user experience. The user can perform interactive data operations such as dragging and sorting on the pivot table, facilitating the user to view the pivot table results in real time for analysis and adjust the pivot table as needed, improving the user's data analysis efficiency. Description of the Drawings

[0017] To more clearly illustrate the technical solutions in the embodiments of the present invention or the prior art, the following will briefly introduce the accompanying drawings required for the description of the embodiments or the prior art. Obviously, the accompanying drawings in the following description are only some embodiments of the present invention. For those of ordinary skill in the art, without creative efforts, other accompanying drawings can be obtained based on these drawings. In the accompanying drawings:

[0018] Figure 1 It is a schematic flowchart of the pivot table processing method in the embodiments of the present invention;

[0019] Figure 2 It is a schematic diagram of the field selector in the embodiments of the present invention Figure 1 ;

[0020] Figure 3 It is a schematic diagram of the field selector in the embodiments of the present invention Figure 2 ;

[0021] Figure 4 It is a specific example diagram of the pivot table in the embodiments of the present invention;

[0022] Figure 5 It is a schematic diagram of the drag and adjustment display of the pivot table in the embodiments of the present invention;

[0023] Figure 6 、 Figure 7 They are respectively schematic diagrams of the pivot table before and after range filtering in the embodiments of the present invention;

[0024] Figure 8 It is a schematic diagram of the numerical sorting display of the pivot table in the embodiments of the present invention;

[0025] Figure 9 It is a schematic diagram of the hierarchical display, folding and unfolding of the pivot table in the embodiments of the present invention;

[0026] Figure 10 It is a schematic diagram of the preservation of the pivot table layout in the embodiments of the present invention;

[0027] Figure 11 It is a schematic diagram of the pivot table loading configuration in the embodiments of the present invention;

[0028] Figure 12 It is a schematic diagram of the pivot table processing device in the embodiments of the present invention. Detailed implementation manners

[0029] To make the objectives, technical solutions, and advantages of the embodiments of the present invention clearer and more understandable, the following will further describe the embodiments of the present invention in detail with reference to the accompanying drawings. Here, the illustrative embodiments of the present invention and their descriptions are used to explain the present invention, but not to limit the present invention.

[0030] A pivot table in a fixed form, that is, the row fields, column fields, data fields, sorting, data display conditions, etc. are all fixed. This form of data display is intuitive and easy to use. For a pivot table in a fixed form, if a user wants to adjust the report form, a new change request needs to be submitted for development, which cannot meet the user's need for flexible data analysis.

[0031] For reports of visual data analysis tool classes, although users can customize the report form, they need to configure a report template first. After the template configuration is completed, the report can be rendered according to the template to display data. Moreover, the reports of visual data analysis tool classes are complex to operate, have a high learning cost, and cannot show the adjustment results in real time, which is not user-friendly.

[0032] In the prior art, when a user analyzes data, they need to dynamically adjust the data range, summary dimension, etc. according to the data situation. If the pivot table template needs to be saved each time, and then the data is loaded and displayed, and the adjusted results cannot be viewed in real time, the user will not be able to immediately know whether the results generated by the current template are what they want. Then, there will be multiple template adjustments and data reloading, which is cumbersome and affects the user's data analysis efficiency.

[0033] An embodiment of the present invention proposes a method for processing a pivot table. When a user views and analyzes data, the user can quickly filter and summarize the data according to different requirements for the data range and dimensions, and display the results in real time according to each user's adjustment, without first creating a pivot table template and then loading the data. The embodiment of the present invention can greatly improve the efficiency of user data analysis.

[0034] Figure 1 It is a schematic flowchart of the method for processing a pivot table in an embodiment of the present invention. As Figure 1 shown, the method includes:

[0035] Step 101: Summarize and display the data to be displayed in a pivot table according to multiple dimension fields; the data to be displayed is classified according to the data content to obtain multiple dimension fields; the display area of the pivot table is divided into row fields, column fields, filter fields, and data fields; the data fields are used to display the values of the dimension fields and statistical summaries.

[0036] Step 102: When a user adjustment instruction for any dimension field is detected, display the adjustment result of the pivot table in real time according to the adjustment instruction; the adjustment instruction is used for interactive data operations on the pivot table, and the adjustment instruction includes dragging a dimension field to any position in any display area of the pivot table.

[0037] When the embodiment of the present invention is implemented, there is no need for front-end and back-end interaction, and it can be implemented only through the front end. The back-end server only provides the original data to be displayed at the initial moment. When the data to be displayed is obtained from the back-end server, the front end starts to execute this method. The front end includes a Web front end and a mobile device front end.

[0038] When initializing the display, according to the general display rules, the data to be displayed is summarized and displayed in a pivot table according to multiple dimension fields.

[0039] For example, unify the format specifications of similar data, sort the list data according to one or some keyword fields, such as in chronological order, numerical size, or alphabetical order, etc., and summarize and display all data in a simple and easy-to-understand manner, facilitating users to quickly obtain the specific content, patterns, and important statistical results of the data without delving into the details.

[0040] Among them, the data to be displayed is classified by data content to obtain multiple dimension fields. For example, in sales data, dimension fields such as year, quarter, month, total sales amount, unit price, etc. can be classified, or in a company's employee list, dimension fields such as department, employee ID number, position, etc. can be classified.

[0041] After that, after the user understands the specific data content, they can make adjustments according to their own needs. During implementation, the user can directly perform interactive data operations such as range selection, dragging, and filtering on the pivot table, and the page dynamically displays the adjustment results in real time.

[0042] In order to further improve the data analysis efficiency and give users more operation options, in one embodiment, before summarizing and displaying the data to be displayed in a pivot table according to multiple dimension fields in step 101, this method may further include:

[0043] Display a field selector; the field selector includes a row field configuration area, a column field configuration area, a filter field configuration area, a data field configuration area, and all dimension fields of the data to be displayed; the field selector is used to: configure the correspondence between the display area of the pivot table and the dimension fields of the data to be displayed, and configure whether the dimension fields are displayed;

[0044] When detecting a selection instruction of a dimension field by the user in the field selector, mark the selected dimension field according to the selection instruction; the selection instruction is used to display or cancel the display of the selected dimension field in the pivot table;

[0045] When detecting a drag instruction of a dimension field by the user in the field selector, drag the selected dimension field to one of the row field configuration area, column field configuration area, filter field configuration area, and data field configuration area.

[0046] Figure 2 Schematic diagram of the field selector in the embodiments of the present invention Figure 1 , such as Figure 2 shown, the field selector page displays a row field configuration area, a column field configuration area, a filtering field configuration area, a data field configuration area, and all dimension fields (month, period, domestic and international identifier, quantity, amount 1, etc.) of the data to be displayed. It may also include a search bar. When there are many dimension fields of the data to be displayed, the specified dimension field can be searched through the search bar.

[0047] Figure 3 Schematic diagram of the field selector in the embodiments of the present invention Figure 2 , such as Figure 3 shown, the user can directly select and drag any dimension field to any configuration area. The configuration areas refer to the row field configuration area, the column field configuration area, the filtering field configuration area, and the data field configuration area. The user can determine which dimension fields are displayed in the pivot table by checking.

[0048] In order to further simplify the user operation and improve the user experience, the user can not perform any operation in the field selector. In one embodiment, when displaying the field selector, it may include: when initializing the display of the field selector, displaying all dimension fields of the data to be displayed in the row field configuration area;

[0049] Summarizing and displaying the data to be displayed in the pivot table according to multiple dimension fields, including: when initializing the display, placing multiple dimension fields of the data to be displayed in the row fields, and the data fields display the values of the corresponding dimension fields.

[0050] Figure 4 Schematic diagram of a specific example of the pivot table in the embodiments of the present invention, such as Figure 4 shown, the display area of the pivot table is divided into row fields, column fields, filtering fields, and data fields. The upper part is mainly the positions of the row fields, column fields, and filtering fields, and the lower data field position displays the detailed-level summary, subtotal-level summary, and total-level summary. Figure 4 The pivot table in Figure 2 is configured through the field selector.

[0051] During implementation, the configuration of the field selector can be skipped, and the initial page of the pivot table can be obtained through automatic initialization and then adjusted without configuration. It is also possible to view the changes of the pivot table in real time through operations such as dragging and checking in the field selector. The field selector can be displayed at the top of the pivot table page, and is expanded and displayed by touching the mouse, retracted and hidden by moving the mouse away. It can be closed through the Figure 2 close mark in the upper right corner. The field selector can also be opened through a button with a setting meaning, for example, refer toFigure 4 Set this button at the upper right corner of the pivot table.

[0052] Further, the adjustment instruction may include dragging a dimension field to any position in any display area of the pivot table. Figure 5 This is a schematic diagram of the drag adjustment display of the pivot table in an embodiment of the present invention. Refer to Figure 5 , the user can dynamically drag any dimension field in the displayed data list to the row field position, column field position, and filter field position, and can also adjust the display order at the same position. For example, drag "number" from the filter field position to the column field position, and drag "international / domestic identifier" from the 3rd in the row field to the 1st. After dragging, the summary result can be displayed in real time. During implementation, the user can achieve dragging only the cell where the dimension field is located, without the need to select an entire row or column for operation.

[0053] In an embodiment, a first specified form is displayed for the positions where the dimension field can be dragged, such as a virtual frame display, and a second specified form is displayed for the positions where the dimension field cannot be dragged. For example, when the mouse moves to a position, a disabled mark is displayed, indicating that the dimension field cannot be dragged to this position.

[0054] After the operation of dragging the dimension field ends, the front end re-filters, sorts, and summarizes the calculation of the original basic data according to the current adjustment operation, without the need to interact with the back end anymore, which is more efficient in data processing and also avoids the impact of the network on the processing efficiency.

[0055] Further, the adjustment instruction may also include performing a display range filter on the values of any dimension field. The user can perform a range filter on any dimension field. Refer to Figure 6 , only filter the data where the "departure station" is DLC, FOC, KMG, PEK, PVG, or XIY. After filtering, the pivot table displays in real time as Figure 7 , it can be seen that the display result is consistent with the filtering result.

[0056] Further, the adjustment instruction may also include performing a numerical sort on the values of any dimension field. Refer to Figure 8 , Figure 8 This is a schematic diagram of the numerical sort display of the pivot table in an embodiment of the present invention. Perform a reverse sort on the row field "departure station" and the column field "number", and the others are sorted in the default ascending order, and the sorting result is displayed in the pivot table in real time.

[0057] Further, the adjustment instruction may also include hierarchical display of multiple dimension fields and collapsing or expanding the hierarchically displayed multiple dimension fields. The user can collapse or expand the record group of any dimension field. When collapsed, the data values summarized to this field level can be viewed. Refer to Figure 9, Figure 9 This is a schematic diagram of the hierarchical display, collapse and expansion of the pivot table in the embodiment of the present invention. When D (domestic and international identifier) > 202310 (month) > 02 (issue) is collapsed to the "issue" level, the data is displayed in real time and summarized to the opening period level; except for the last level in the row field and column field, each level can be expanded and collapsed.

[0058] In one embodiment, when a user's adjustment instruction for any dimension field is detected, after the adjustment result of the pivot table is displayed in real time according to the adjustment instruction, the method may further include: saving the current pivot table layout as a configuration file through a download interface; or, loading a pre-saved configuration file through an upload interface.

[0059] In one embodiment, when a user's adjustment instruction for any dimension field is detected, after the adjustment result of the pivot table is displayed in real time according to the adjustment instruction, the method may further include: configuring the current pivot table layout as the default startup state.

[0060] Reference Figure 10 , Figure 10 This is a schematic diagram of saving the pivot table layout in the embodiment of the present invention. The user can perform a "save" operation on the current layout with a custom layout name. During implementation, multiple layouts are supported for saving, which is convenient for subsequent direct use according to needs without further adjustment.

[0061] Continue to refer to Figure 10 , when the "default" button is clicked, it is regarded as configuring the current pivot table layout as the default startup state, and the current pivot table layout will be used by default when starting next time.

[0062] Figure 11 This is a schematic diagram of loading the configuration of the pivot table in the embodiment of the present invention. Refer to Figure 11 , the layout to be loaded can be clicked, and the pivot table of the layout will be displayed in real time.

[0063] In the embodiment of the present invention, the pivot table processing method divides the pivot table into row fields, column fields, filter fields, and data fields (numeric type fields for statistical summarization). The user can check, uncheck, or drag the position of the fields in the field selector; the summary calculation mode includes detail level (data row) summary, subtotal level summary, and total level summary. When initializing the display, summary display can be performed according to general display rules (such as: putting all dimension fields that are not specific data fields into the row fields, and putting the fields for summarization into the data fields), which is convenient for users to have a preliminary understanding of the data.

[0064] Users can drag dimension fields, including row fields, column fields, and filtering fields (e.g., a row field can be dragged into a column field, or a filtering field can be dragged into a row field), among each other; they can directly perform range filtering and sorting on dimension fields, and perform real-time calculations on the results after dragging, filtering, and sorting, and display the results on the page; expanding a dimension field can display summary data at a further detailed level, and collapsing a dimension field can display the data summarized at the current level.

[0065] For the fields existing in the row field and column field areas, there is no need to drag them into the field filter for condition configuration. Instead, filtering is directly performed by checking the conditional data. Only the fields that are not displayed in tabular form (such as row fields, column fields, etc.) can be dragged into the field filter. This design not only takes into account that most filtering / sorting operations are targeted at the displayed fields, and dragging them into the field filter for condition configuration will increase the complexity of user operations. Checking the data directly on the displayed fields for filtering greatly simplifies user operations and increases convenience; it also takes into account that in special cases, some non-displayed fields need to be used as conditions for supplementation.

[0066] In the embodiments of the present invention, these operations do not require the backend to query the data again and return it to the frontend. Only the frontend re-filters, sorts, and summarizes based on the original data returned by the initial backend and renders the results on the page. This reduces the time for the backend to query the database again and the interaction time between the front and backend, the data feedback effect is more rapid, and the backend overhead is also reduced.

[0067] In the embodiments of the present invention, a pivot table processing device is also provided, as described in the following embodiments. Since the principle of the device for solving problems is similar to that of the pivot table processing method, the implementation of the device can refer to the implementation of the pivot table processing method, and the repeated parts will not be described again.

[0068] Figure 12 is a schematic diagram of the pivot table processing device in the embodiments of the present invention, as Figure 12 shown. The device 1200 can be implemented only through the frontend. The device 1200 includes:

[0069] An initialization display module 1201, configured to summarize and display the data to be displayed in a pivot table according to multiple dimension fields; the data to be displayed is classified according to the data content to obtain multiple dimension fields; the display area of the pivot table is divided into row fields, column fields, filtering fields, and data fields; the data fields are used to display the values of the dimension fields and statistical summaries;

[0070] An interaction adjustment module 1202, configured to, when detecting an adjustment instruction of a user for any dimensional field, display the pivottable adjustment result in real time according to the adjustment instruction; the adjustment instruction is used for performing interactive data operations on the pivottable, and the adjustment instruction includes dragging the dimensional field to any position in any display area of the pivottable.

[0071] In one embodiment, the adjustment instruction further includes: performing display range filtering and numerical sorting on the values of any dimensional field, performing hierarchical display on multiple dimensional fields, and collapsing or expanding the multiple hierarchically displayed dimensional fields.

[0072] In one embodiment, the apparatus further includes: a field selector configuration module, configured to:

[0073] display a field selector; the field selector includes a row field configuration area, a column field configuration area, a filter field configuration area, a data field configuration area, and all dimensional fields of the data to be displayed; the field selector is configured to: configure the correspondence between the display area of the pivottable and the dimensional fields of the data to be displayed, and configure whether to display the dimensional fields;

[0074] when detecting a selection instruction of a user for a dimensional field in the field selector, mark the selected dimensional field according to the selection instruction; the selection instruction is used for displaying or canceling the display of the selected dimensional field in the pivottable;

[0075] when detecting a drag instruction of a user for a dimensional field in the field selector, drag the selected dimensional field to one of the row field configuration area, the column field configuration area, the filter field configuration area, and the data field configuration area according to the drag instruction.

[0076] In one embodiment, the field selector configuration module is specifically configured to: when initializing and displaying the field selector, display all dimensional fields of the data to be displayed in the row field configuration area;

[0077] The initialization display module is specifically configured to: when initializing the display, place multiple dimensional fields of the data to be displayed in the row field, and display the values of the corresponding dimensional fields in the data field.

[0078] In one embodiment, the apparatus further includes: a saving module, configured to save the current pivottable layout as a configuration file through a download interface; and / or, a loading configuration module, configured to load a pre-saved configuration file through an upload interface.

[0079] In one embodiment, the apparatus further includes: a default start configuration module, configured to configure the current pivottable layout as the default start state.

[0080] An embodiment of the present invention further provides a computer device, including a memory, a processor, and a computer program stored on the memory and executable on the processor. When the processor executes the computer program, the above data pivot table processing method is implemented.

[0081] An embodiment of the present invention further provides a computer-readable storage medium. The computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, the above data pivot table processing method is implemented.

[0082] An embodiment of the present invention further provides a computer program product. The computer program product includes a computer program, and when the computer program is executed by a processor, the above data pivot table processing method is implemented.

[0083] In summary, the embodiments of the present invention have the following beneficial technical effects:

[0084] (1) Users can directly view the data of the data pivot table under the standard configuration without having to configure the data pivot table template in advance, reducing the user operation steps and complexity.

[0085] (2) Users can select the fields to be displayed according to the display results of the data pivot table, and can dynamically drag the dimension fields, filter and sort the dimension fields, and expand / collapse the record groups of the dimension fields. All of the above operations can, according to each dynamic adjustment, display the summary results in the data pivot table in real time. This facilitates users to view the data results in real time for analysis, adjust the data pivot table as needed, and improve the user data analysis efficiency.

[0086] (3) Users can save the adjustment results of the data pivot table and support saving multiple copies, which is convenient for direct use next time without having to adjust again, improving the user data analysis efficiency.

[0087] Those skilled in the art should understand that the embodiments of the present invention can be provided as a method, a system, or a computer program product. Therefore, the present invention can take the form of a complete hardware embodiment, a complete software embodiment, or an embodiment combining software and hardware aspects. Moreover, the present invention can take the form of a computer program product implemented on one or more computer-usable storage media (including but not limited to disk storage, CD-ROM, optical storage, etc.) containing computer-usable program code.

[0088] The present invention is described with reference to the flowcharts and / or block diagrams of methods, apparatuses (systems), and computer program products according to embodiments of the present invention. It should be understood that each flow and / or block in the flowcharts and / or block diagrams, as well as the combination of flows and / or blocks in the flowcharts and / or block diagrams, can be implemented by computer program instructions. These computer program instructions can be provided to the processor of a general-purpose computer, a special-purpose computer, an embedded processor, or other programmable data processing devices to generate a machine, such that the instructions executed by the processor of the computer or other programmable data processing devices produce means for implementing the functions specified in the Figure 1 one or more flows and / or blocks Figure 1 one or more blocks.

[0089] These computer program instructions can also be stored in a computer-readable memory that can direct a computer or other programmable data processing device to work in a specific manner, such that the instructions stored in the computer-readable memory produce a manufactured article including instruction means that implement the functions specified in the Figure 1 one or more flows and / or blocks Figure 1 one or more blocks.

[0090] These computer program instructions can also be loaded onto a computer or other programmable data processing device, such that a series of operation steps are executed on the computer or other programmable device to generate a computer-implemented process, and thus the instructions executed on the computer or other programmable device provide steps for implementing the functions specified in the Figure 1 one or more flows and / or blocks Figure 1 one or more blocks.

[0091] The specific embodiments described above further elaborate on the objectives, technical solutions, and beneficial effects of the present invention. It should be understood that the above are only specific embodiments of the present invention and are not used to limit the protection scope of the present invention. Any modifications, equivalent replacements, improvements, etc. made within the spirit and principles of the present invention shall be included in the protection scope of the present invention.

Claims

1. A method for processing a pivot table, characterized in that The method is implemented through the front end, and the method includes: Summarize and display the data to be displayed in a pivot table according to multiple dimension fields; the data to be displayed is classified by data content to obtain multiple dimension fields; the display area of the pivot table is divided into row fields, column fields, filter fields, and data fields; the data field is used to display the values of the dimension fields and statistical summaries; When a user adjustment instruction for any dimension field is detected, display the pivot table adjustment result in real time according to the adjustment instruction; the adjustment instruction is used to perform interactive data operations on the pivot table, and the adjustment instruction includes dragging a dimension field to any position in any display area of the pivot table.

2. The method according to claim 1, characterized in that The adjustment instruction further includes: performing display range filtering and numerical sorting on the values of any dimension field, performing hierarchical display on multiple dimension fields, and collapsing or expanding the multiple dimension fields subjected to hierarchical display.

3. The method according to claim 1, wherein Before summarizing and displaying the data to be displayed in a pivot table according to multiple dimension fields, it further includes: Display a field selector; the field selector includes a row field configuration area, a column field configuration area, a filter field configuration area, a data field configuration area, and all dimension fields of the data to be displayed; the field selector is used to: configure the corresponding relationship between the display area of the pivot table and the dimension fields of the data to be displayed, and configure whether the dimension fields are displayed; When a user selection instruction for a dimension field in the field selector is detected, mark the selected dimension field according to the selection instruction; the selection instruction is used to display or cancel the display of the selected dimension field in the pivot table; When a user drag instruction for a dimension field in the field selector is detected, drag the selected dimension field to one of the row field configuration area, column field configuration area, filter field configuration area, and data field configuration area according to the drag instruction.

4. The method according to claim 2, characterized in that, Display a field selector, including: When initializing and displaying the field selector, display all dimension fields of the data to be displayed in the row field configuration area; Summarize and display the data to be displayed in a pivot table according to multiple dimension fields, including: When initializing and displaying, place multiple dimension fields of the data to be displayed in the row field, and the data field displays the values of the corresponding dimension fields.

5. The method according to any one of claims 1 to 4, characterized in that When a user adjustment instruction for any dimension field is detected, after displaying the pivot table adjustment result in real time according to the adjustment instruction, it further includes: Save the current pivot table layout as a configuration file through a download interface; And / or, load a pre-saved configuration file through an upload interface.

6. The method according to any one of claims 1 to 4, characterized in that When a user adjustment instruction for any dimension field is detected, after displaying the pivot table adjustment result in real time according to the adjustment instruction, it further includes: Configure the current pivot table layout as the default startup state.

7. A pivot table processing device, characterized in that, The device is implemented through the front end, and the device includes: An initialization display module, used to summarize and display the data to be displayed in a pivot table according to multiple dimension fields; the data to be displayed is classified by data content to obtain multiple dimension fields; the display area of the pivot table is divided into row fields, column fields, filter fields, and data fields; the data field is used to display the values of the dimension fields and statistical summaries; An interaction adjustment module, configured to, when detecting an adjustment instruction of a user for any dimensional field, display the adjustment result of the pivot table in real time according to the adjustment instruction; the adjustment instruction is used for performing interactive data operations on the pivot table, and the adjustment instruction includes dragging the dimensional field to any position in any display area of the pivot table.

8. The device according to claim 7, characterized in that, The adjustment instruction further includes: performing display range filtering and numerical sorting on the values of any dimensional field, performing hierarchical display on multiple dimensional fields, and collapsing or expanding the multiple dimensional fields subjected to hierarchical display.

9. The device according to claim 7, wherein, It further includes: A field selector configuration module, configured to: Display a field selector; the field selector includes a row field configuration area, a column field configuration area, a filter field configuration area, a data field configuration area, and all dimensional fields of the data to be displayed; the field selector is used for: configuring the correspondence between the display area of the pivot table and the dimensional fields of the data to be displayed, and configuring whether the dimensional fields are displayed; When detecting a selection instruction of a user for a dimensional field in the field selector, marking the selected dimensional field according to the selection instruction; the selection instruction is used for displaying or canceling the display of the selected dimensional field in the pivot table; When detecting a drag instruction of a user for a dimensional field in the field selector, dragging the selected dimensional field to one of the row field configuration area, the column field configuration area, the filter field configuration area, and the data field configuration area according to the drag instruction.

10. The device according to claim 9, wherein The field selector configuration module is specifically configured to: when initializing and displaying the field selector, display all dimensional fields of the data to be displayed in the row field configuration area; The initialization display module is specifically configured to: when initializing the display, place multiple dimensional fields of the data to be displayed in the row field, and display the values of the corresponding dimensional fields in the data field.

11. The device according to any one of claims 7 to 10, characterized in that, It further includes: A saving module, configured to save the current pivot table layout as a configuration file through a download interface; And / or, a loading configuration module, configured to load a pre-saved configuration file through an upload interface.

12. The device according to any one of claims 7 to 10, characterized in that It further includes: A default start configuration module, configured to configure the current pivot table layout as the default start state.

13. A computer device, comprising a memory, a processor, and a computer program stored on the memory and executable on the processor, characterized in that, The processor, when executing the computer program, implements the method according to any one of claims 1 to 6.

14. A computer-readable storage medium, characterized in that, The computer-readable storage medium stores a computer program, and when the computer program is executed by the processor, it implements the method according to any one of claims 1 to 6.

15. A computer program product, characterized in that, The computer program product includes a computer program, and when the computer program is executed by the processor, it implements the method according to any one of claims 1 to 6.

Images