I used igPivotGrid with below config
$('#pivotGrid').igPivotGrid allowSorting: true allowHeaderRowsSorting: true allowHeaderColumnsSorting: true firstSortDirection: 'ascending' firstLevelSortDirection: 'ascending' dataSource: dataSource height: '704px' width: '100%' compactColumnHeaders: false compactRowHeaders: false
and my pivotGird show like
I want to remove summary columns/rows(All country, All category) when I expanded rows/columns.
I try to remove it by remove levels hierarchies in option dimensions of cube
hierarchies: [ {... levels: [# {# name: "All#{column_name[1]}"# caption: "All #{column_name[0]}"# memberProvider: App.Pivot.nameAllMemberProvider(column_name)# }, { name: column_name[1] caption: column_name[0] memberProvider: App.Pivot.memberProvider(column_name) } ]
... } ]
but when pivotGrid can't expand/collapse rows/columns. How to remove summary rows/column and keep expand/collapse ?
Hello Bui,
I'm currently looking into your question. I will get back to you as soon as I have an update.
Thank you,Mihoko Kamiishi
After investigating this and doing some research, removing the summary row or column while keeping expand/collapse functionalities has been determined to be a new product idea. You can suggest new product ideas for future versions (or vote for existing ones) at <http://ideas.infragistics.com>.Submitting your idea will allow you to communicate directly with our product management team, track the progress of your idea at any time, see how many votes it got, read comments from other developers in the community, and see if someone from the product team has additional questions for you.Remember when submitting your idea to explain the context in which a feature would be used and why it is needed as well as anything that would prevent you from accomplishing this today. You can even add screenshots to build a stronger case. Remember that for your suggestion to be successful, you need other members of the community to vote for it. You can also link back to this thread for additional details.Thank you in advance to submitting your product idea.