Pivot Issues

[EPM Solutions]

Hello,

       1) Can you tell me that why all column are showing in aggregation while I am applying only on two column(as in screenshot and plunker)? In Screenshot I have highlighted the unwanted column. I am also providing the code of my groupModel.

2) If I am removing the summary.type then why it is not showing the summary total or row total in grid in normal mode?

Please provide a solution
Plunker url:
https://next.plnkr.co/edit/Ct7jrEcYWOqkY8cT

[paramvir]

Please remove column.summary.type from all unwanted columns except proBudget & proOverUnder

https://next.plnkr.co/edit/uhUlcokYBsGT2SeS

[EPM Solutions]

Hello Team,

Thanks for your quick reply.

But after removing summary.type we are no longer to see Summary in Title row.

Our requirement is we need to show Total Summary in Title row and in the Pivot mode we need only 2 columns in Aggregation Panel.

Please give your feedback asap.

[paramvir]

Please confirm your requirements:

You want to apply aggregates to all columns in row grouping mode while apply aggregates to only 2 columns in pivot mode.

If I am removing the summary.type then why it is not showing the summary total or row total in grid in normal mode?

Please define normal mode.

[EPM Solutions]

Hello Team,

Normal Mode = Without Pivot Mode

If we remove summay.title from column in normal mode it stop showing Summary in Group Row Title.

Please check attached Image.

Plunker:
https://next.plnkr.co/edit/k3gYbolblYFomTMn

Our Requirtment:
1. We want to show summary for all columns in Group Row Title in Normal Mode.

2. And when we change Normal Mode to Pivot Mode we want to show only 2 columns in aggregation.


Please check above details and let us know if you require any further information.

[paramvir]

you can use groupOption event to switch between 2 column aggregates and all column aggregates.

Code: [Select]

groupOption: function(evt, ui){
        var newPivot = this.option('groupModel.pivot');
       
        //pivot turned on
        if( newPivot && !ui.oldGM.pivot ){
          this.getColModel().forEach(function(col){
            if(col.dataIndx != "proBudget" && col.dataIndx != 'proOverUnder' ){
              col.summary = null;
            }
          })
        }
        //pivot turned off
        else if( !newPivot && ui.oldGM.pivot ){
            this.getColModel().forEach(function(col){
              col.summary = {type:'all'};
            })
        }
        //debugger;
      },


[EPM Solutions]

Hello Team,

                Thank you for your reply.

                We applied the above code but still it is showing the other columns(like Original Budget,Budget Adjustments etc) in aggregates with projected budget and Projected Over/Under. Is it not possible to hide the columns from aggregates without removing the summary.type ?

Second point is, when we are changing the summaryOption by clicking on the sum of projected Budget in Aggregates of tool Panel then aggregation applies on other columns that is not correct. Please give the solution in a plunker and let me know if any query regarding the above points.

Plunker:
https://next.plnkr.co/edit/Ct7jrEcYWOqkY8cT

[EPM Solutions]

Hello Team,

                After updating your code, aggregation is showing only on two columns (proBudget & proOverUnder) but still other columns are also showing in aggregate in Tool Panel. Please provide a solution to put only two columns in aggregates as used in group Model(proBudget & proOverUnder).

[paramvir]

It's to be expected that whatever columns have summary property defined would show up in aggregates pane in tool Panel.

However if you want to hide them, then please add tpHide: true to the columns as answered in one of the previous posts.

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