Why the all columns are coming in aggregation?

[EPM Solutions]

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

[paramvir]

I see aggregates defined for all columns in plnkr.

Code: [Select]

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

Please remove summary.type from unwanted columns.

[EPM Solutions]

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.

[paramvir]

Columns can be hidden in toolPanel with tpHide property.

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

[EPM Solutions]

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.

[paramvir]

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