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 !!
Forums Home / Wijmo / General Discussion
Posted by: chayankar209 on 26 April 2018, 4:00 pm EST
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 !!
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:
~Manish