Skip to content
← The place of ONLYOFFICE ideas

Settings and activity

1 result found

  1. Please add Pivot Analyzer just like it is in Excel

    2 votes

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    6 comments  ·  Your Voice Matters » Document Editors  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback
    Signed in as (Sign out)
    Close
    Close
    An error occurred while saving the comment
    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

    An error occurred while saving the comment
    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

    An error occurred while saving the comment
    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

    Prajwal Chittora shared this idea  ·