ParamQuery grid support forum

General Category => Help for ParamQuery Pro => Topic started by: EPM Solutions on October 24, 2018, 01:08:35 pm

Title: Pivot collapse
Post by: EPM Solutions on October 24, 2018, 01:08:35 pm

Hello team,
 
here we have a requirement (referring below attached Image ), in YEAR column 2020 we have only one quarter Q2, and Q2 contains only one month(may). Here can we display  leaf div(forecast to complete) under 2020 even though 2020 contains only one quarter and after expanding 2020 it should show Q2 and under Q2 again forecast to complete should come unless Q2 is expanded. 

On load it should not show yellow colored highlighted columns(as shown in the image).

Title: Re: Pivot collapse
Post by: paramvir on October 24, 2018, 10:56:37 pm

I'm afraid there is no option to do that currently.

It would be added in next upcoming version ETA: 15 Nov

Title: Re: Pivot collapse
Post by: EPM Solutions on November 29, 2018, 09:45:05 am

Hello Team,

Any update on this. If updated please share an example so we can implement same in our code.

Thanks in advance.

Title: Re: Pivot collapse
Post by: paramvir on November 29, 2018, 10:01:08 am

Please use pivotTotalForSingle: true sub-option in groupModel.

https://paramquery.com/pro/api#option-groupModel