Author Topic: Pivot column cascading issue  (Read 2002 times)

EPM Solutions

  • Pro Ultimate
  • Full Member
  • *
  • Posts: 182
    • View Profile
Pivot column cascading issue
« on: October 12, 2018, 03:25:28 pm »
Hello team,

we have developed the pivot grid as the example https://plnkr.co/edit/7Fix2YozTqnshevob54w?p=preview. here If I have single column under Year Column it wont get cascaded. Our developed link is given below.

https://plnkr.co/edit/nTjsZyLt2FR2I3llajyp?p=preview

here in this code, we have column like 2016,2018,2019 and 2020. In each we have quarters. But only 2018 shows as expected cascading, can you please tell me why we are not getting other columns as 2019 column is cascaded. And we have only quarter under other remaining year column. Here 2019 has 2 quarters but below that sum(Forecast to Complete) should have come, but it is showing different. Can you tell how is possible to make it like column 2018.

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6265
    • View Profile
Re: Pivot column cascading issue
« Reply #1 on: October 15, 2018, 10:58:05 am »
Your code is fine.

and years 2016, 2018 and 2020 are correct.

When there is only column, then aggregate of that column is not displayed, e.g, year 2016 has only one quarter i.e., Q3, so its aggregate is not required.

Year 2019 has 2 quarters, so its aggregate is expected to be displayed; means there is an issue for year 2019.

This issue is corrected in v5.5.0, please check this plnkr: https://plnkr.co/edit/ixp2sSZfQcHmR8qDS3Gm?p=preview

PS: v5.5.0 would be released shortly.
« Last Edit: October 15, 2018, 11:00:40 am by paramquery »

EPM Solutions

  • Pro Ultimate
  • Full Member
  • *
  • Posts: 182
    • View Profile
Re: Pivot column cascading issue
« Reply #2 on: October 16, 2018, 09:56:47 am »
Hello team,

thank you. Here am getting result in plunkr, but when I apply same code to my SharePoint application, Am getting some error so am not able to display the grid. Error msg Image is attached below, can you please tell whether the issue is with library or anything else. Because we are getting new issue here.

here I used same code and same library files.

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6265
    • View Profile
Re: Pivot column cascading issue
« Reply #3 on: October 16, 2018, 03:45:01 pm »
I found multiple versions of jquery ( 1.8.3 & 2.2.4) in your sharepoint and the error is caused by conflict between jQuery 1.8.3 and ScriptResource.xsd

Please remove jQuery v1.8.3