EasyUI Forum

General Category => General Discussion => Topic started by: unsui on February 26, 2017, 08:01:42 AM

Title: pivotgrid filter row
Post by: unsui on February 26, 2017, 08:01:42 AM

How can I add Filter rows to pivotgrid? Like Datagrid.

Title: Re: pivotgrid filter row
Post by: jarry on February 26, 2017, 05:00:30 PM

The pivotgrid has the built-in filter functionality. Please set the 'filters' property or call the 'layout' method to modify it.

Code:

pivot:{
	rows:['Country','Category'],
	columns:['Color'],
	filters:['Destination'],
	values:[
		{field:'Price',op:'sum'},
		{field:'Discount',op:'sum'}
	]
},

Title: Re: pivotgrid filter row
Post by: unsui on March 01, 2017, 06:41:23 PM

thank you for your answer. But, I want the following Filter row.(DataGrid Filter Row)
https://www.jeasyui.com/demo/main/index.php?plugin=DataGrid&theme=default&dir=ltr&pitem=# (https://www.jeasyui.com/demo/main/index.php?plugin=DataGrid&theme=default&dir=ltr&pitem=#)

Isn't a Filter like the attached image.

Is't possible to realize Fiter row like DataGrid with PivotGrid?

Title: Re: pivotgrid filter row
Post by: jarry on March 02, 2017, 01:01:36 AM

No, the pivotgrid has its own filtering behavior. It isn't a good idea to display all the filtering box on all the columns.