The usage of sortableGroups in OLAP

The usage of sortableGroups in OLAP

Posted by: hanniewang on 1 August 2018, 2:31 pm EST

• 

  hanniewang

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 1 August 2018, 2:31 pm EST

  Hi,

  I want to know how OLAP Engine’s “sortableGroups” attribute is used. Does it work only if it is set to showRowTotals: wijmo.olap.ShowTotals.Subtotals?

  I would like to sort in groups without setting this property. Do you have any suggestions?

  Best Regards,
  
  Hanny

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 1 August 2018, 11:24 pm EST

  Hi,
  
  Yes, you are right to notice that sortableGroups work only when showRowTotals is set to ‘Subtotals’.

  However, if you would like to sort within groups without setting showRowTotals to ‘Subtotals’ then you may use collectionView’s sortComparer and sortConverter properties to get the desired functionality.

  Please refer to the following sample which implements the same:-
  
  https://stackblitz.com/edit/js-htmzet?file=index.js

  ~Manish

• 

  hanniewang

  • Post Options:
  • Link
    Copy

  Posted 2 August 2018, 6:26 pm EST

  Hi Manish,

  Thank you for your help and your reply.

  But I found another problem with demo: by clicking on the sorted measure column, the first column, “Country” column, is always in ascending order.

  js-htmzet.zip

  Best Regards,
  
  Hanny

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 5 August 2018, 11:32 pm EST

  Hi,
  
  We are indeed sorry for the issue in the last sample.

  Please refer to the following updated sample:-
  
  https://stackblitz.com/edit/js-osswdm?file=index.js

  Regards