« previous next »
Pages: [1]

Author Topic: Pivot collapse  (Read 2213 times)

EPM Solutions

  • Pro Ultimate
  • Full Member
  • *
  • Posts: 182
    • View Profile
Pivot collapse
« 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).
Logged

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6309
    • View Profile
Re: Pivot collapse
« Reply #1 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
Logged

EPM Solutions

  • Pro Ultimate
  • Full Member
  • *
  • Posts: 182
    • View Profile
Re: Pivot collapse
« Reply #2 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.
Logged

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6309
    • View Profile
Re: Pivot collapse
« Reply #3 on: November 29, 2018, 10:01:08 am »
Please use pivotTotalForSingle: true sub-option in groupModel.

https://paramquery.com/pro/api#option-groupModel
Logged
Pages: [1]
« previous next »