Pricing changes are coming in January. Contact our Sales team to secure the current price for your desired license.

pivot table customize option.

Answered
vinoth asked on November 11, 2024

Hi team,

When the user right click on pivot table column it shows up the option for "move to report filters". I want to capture this events and add the currently clicked column to "report filter" inside fields dialog. 

customizeContextMenu =  (items: ContextMenuItem[], data: CellData) => {

 const menuitem = items.find((item)=>item.id === 'move_to_report_filters');
            menuitem.handler = () =>  {

}

}

3 answers

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster November 11, 2024

Hello, Vinoth!

Thank you for reaching out to us.

If we understand the request correctly, you want to use the context menu inside the Field List. If so, please note that you can use our accessibility feature to open the context menu in the Field List and use it instead of drag-n-drop to move fields to Rows, Columns, Measures or Report FIlters. Here is the video to illustrate the idea: https://youtu.be/LOKEk829KpI?si=RHcA7NeCdW4uKEcg.

You can find more details about the accessibility in Flexmnoster by the link: https://www.flexmonster.com/doc/keyboard-navigation/.

Hope you will find our answer helpful.

Kind regards,
Solomiia

 

Public
vinoth November 12, 2024

HI ,

I wanted to handle "Move to Report Filters" callback , when ever user clicks on "move to report filters" selected columns should be added to Report filter inside field's option dialog.

https://jsfiddle.net/flexmonster/owo7987L/

 

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster November 12, 2024

Hello, Vinoth!

Thank you for getting back to us.

Kindly note that customizeContextMenu() API call works only for the context menu on the grid. "Move to Report Filters" in the context menu changes the field position in both grid visualization and Field List, as it updates the field position in the report.slice. There is no approach to adding a customizable context menu to the Field List separately or changing the one that opens using key navigation.

Hope it helps.

Kind regards,
Solomiia

 

Please login or Register to Submit Answer