ParamQuery grid support forum

General Category => Help for ParamQuery Pro => Topic started by: EPM Solutions on April 08, 2019, 05:10:03 pm

Title: Why the all columns are coming in aggregation?
Post by: EPM Solutions on April 08, 2019, 05:10:03 pm

Hello,

         Whenever I am changing the normal grid to Pivot grid. Why the all columns are coming in aggregation(where i am applying only on two columns, projected Budget and projected Over/Under) ?
Also tell me the way by which I can remove aggregation sum(sum: symbol) which is coming in the normal and pivot grid on applying aggregation in my original Grid.
Here I have written a sample grid(Please check the link and give me the solution).
https://next.plnkr.co/edit/AXhaBJekR15q1prz

Title: Re: Why the all columns are coming in aggregation?
Post by: paramvir on April 09, 2019, 01:20:26 pm

I see aggregates defined for all columns in plnkr.

Code: [Select]

summary: {
       type: "all" //use custom aggregate.
}

Please remove summary.type from unwanted columns.

Title: Re: Why the all columns are coming in aggregation?
Post by: EPM Solutions on April 09, 2019, 05:23:22 pm

Hello,
 
        Thanks,
        Can you tell me that How can I hide some column which are hidden in normal mode, but it is showing in Pivot mode of grid? I want to hide some column from Pivot mode and also (if possible) from aggregates in pivot mode. I have added a screenshot please check it and give me solution.

Title: Re: Why the all columns are coming in aggregation?
Post by: paramvir on April 09, 2019, 10:49:46 pm

Columns can be hidden in toolPanel with tpHide property.

https://paramquery.com/pro/api#option-column-tpHide

Title: Re: Why the all columns are coming in aggregation?
Post by: EPM Solutions on April 10, 2019, 12:46:26 pm

Hello,

       Thank you,
       As you told in previous reply that I should remove the summary.type from unwanted column. If I tell that these (summary) are required feature for my grid. Then it is possible to hide the fields from the aggregation of tool panel and show them to top of the tool panel like other column(Rec,Title etc.). Please provide a solution.

Title: Re: Why the all columns are coming in aggregation?
Post by: paramvir on April 10, 2019, 06:16:30 pm

I'm sorry what's your latest question. Is tpHide or column.summary.type not working for you? Please share a plnkr