Please add Pivot Analyzer just like it is in Excel
I can see that there is no Pivot Analyzer in OnlyOffice spreadsheets, though there are pivot tables but for creating a functional dashboard features like Pivot Analyzer and connecting a slicer with multiple pivot tables just like in Excel, a Pivot Analyzer tab just like in Excel is necessary.
It is planned in one of the future releases.
-
AdminAlexandre (Admin, ONLYOFFICE) commented
Hello,
There's no ETA at the moment as we're still working on it. -
Prajwal Chittora commented
Hi Admin,
Can you tell me more about this future release? If you can provide a rough timeline it would be very helpful -
AdminConstantine (Admin, ONLYOFFICE) commented
Thanks for the comments. We need some time to review this suggestion.
-
Prajwal Chittora commented
It will be really helpful for my business if the OnlyOffice team can replicate this feature of MS Excel on their OnlyOffice Spreadhseets. Although, I cannot find any exact documentation describing the exact functionalities, you can try using this feature on MS Excel and chart out the exact specifications, or we can collaborate and work towards that document together, I really need this feature and would be happy to contribute in whatever way possible
-
Prajwal Chittora commented
Hi Constantine,
I am sharing a few articles on Pivot Analyze feature in Excel, and other features of Slicers that are there in Excel, I am talking about Microsoft Excel (MS Excel) here.OnlyOffice has Pivot Tables, but it does not have the feature to create a Pivot Chart which MS Excel has, now a Pivot Chart and a Chart is different as a Pivot Chart is more dynamic in nature than a normal Chart, by dynamic I mean, the data changes as the pivot table changes, you can copy the pivot chart in the different sheet in the same excel file to create a dashboard and the chart stays connected with the pivot table, similarly, slicers work in a similar fashion in MS Excel, you can connect the slicer to multiple Pivot Tables and copy the slicer to a different sheet in the same excel file for dashboarding purposes.
The links of articles for reference -
1. https://www.simplesheets.co/blog/connect-slicer-to-multiple-pivot-tables-in-excel
2. https://support.microsoft.com/en-us/office/use-pivottables-and-other-business-intelligence-tools-to-analyze-your-data-da1b3e85-d3c0-4f15-8cd9-bef446762ec3 -
AdminConstantine (Admin, ONLYOFFICE) commented
Please share a link to the documentation that describes capabilities of Pivot Analyzer for the reference.