How do you modify pivotfieldlist markup

[tttrickyyy]

I have a requirement to allow the end user to select ALL columns (rather than single click each one). I was hoping there was a way to either manipulate the pivotfieldlist markup (ie, is there a way to customize that UI and add a button) or a way to template it and override the underlying UI?

[Sivamathi Natarajan]

Hi Tricky, 

 

Thank you for using Syncfusion products. 

 

We follows Excel behavior for UI and actions of field list. And its UI couldn’t be customized by end user. So, could you please provide us your exact requirement and purpose so that we will check the possibilities to achieve the same. 

 

Regards, 

Sivamathi. 

[tttrickyyy]

Sorry for the confusion. The expectation is not for the end user to modify the UI but for us (the dev team) to modify the UI to allow for the ability to "Select all Columns" and also customize the field list UI.

The exact requirement would be :

"Provide the ability to select all columns in the pivotfieldlist". Currently to "Show or hide" columns in the field list you must click each one individually. 

[Sivamathi Natarajan]

Hi Tricky, 

 

Due to framework difficulties the UI of the field list couldn’t be customized. But your requirement can be achieved by external actions like button click, check box check etc.. Here while performing external action, the fields that are not bound in the report should be bind in desired axis. So that all the fields in field list will be checked and the appropriate changes in the pivot table will be done. This is the only possible solution. 

 

We have prepared a stand-alone sample for your reference which is available in following link. 

 

Sample link: https://www.syncfusion.com/downloads/support/directtrac/general/ze/Pivot_Table1202716810 

 

Regards,
Sivamathi.