Customize Pivot Panel

Posted by: chayankar209 on 26 April 2018, 4:00 pm EST

    • Post Options:
    • Link

    Posted 26 April 2018, 4:00 pm EST

    Hello,

    Is it possible to customize the view and options available in Pivot Panel view ?

    I want to show the only rows or columns option. How can it be acheived ?

    Thank you !! :slight_smile:

  • Posted 29 April 2018, 7:48 pm EST

    Hi,

    Yes, pivotPanel can be customized and targeted fields can be hide by setting display to none.

    Please refer to the following demo fiddle for the same:

    http://jsfiddle.net/rykygo6t/

    ~Manish

  • Posted 29 April 2018, 10:23 pm EST

    Wow… Thanks a lot ! The pivot panel is having check box against the data columns. Upon checking the boxes only the data coulmn which are of type string gets selected for rows section. I want the numeric data columns to be selected under rows section on checking them.

    Please suggest.

  • Posted 30 April 2018, 7:58 pm EST

    Hi,

    The Fields with numeric data gets added under values fields and Fields with String,Date and Boolean gets added to Rows Section.

    Later, you can move them between other section from PivotPanel.

    Please refer to the fiddle for the same:

    http://jsfiddle.net/rykygo6t/1/

    Also, please let us know which fields you would like to add in values fields to show data in PivotField.

    ~Manish

  • Posted 1 May 2018, 6:50 pm EST - Updated 3 October 2022, 11:30 am EST

    I made a workaroud where only rows and values section will be visible in Pivot Panel. I had to make the values field visible because of the checkbox thing. If I hide the values section and user clicks on the check box, then there is no effect on the screen.

    If you could tell me how to hide the defer update section and increase the cell width of rows and value section then it will be really helpful.

    Refer to the screenshot for more clarity.

    Again, Thanks Manish, for your continuous support.

  • Posted 2 May 2018, 2:13 pm EST

    Hi,

    For this you need to customize Layout and hide desired fields. Please see the fiddle for the same:

    http://jsfiddle.net/0ocm86xk/

    ~Manish

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels