OLAP: how to get difference value from comparing two different column value

OLAP: how to get difference value from comparing two different column value

Posted by: subakaranmca on 5 December 2018, 5:48 am EST

• 

  subakaranmca

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 5 December 2018, 5:48 am EST - Updated 3 October 2022, 8:16 pm EST

  

  here I want to get Unit value which is ( 5WK bwd - 5WK Fwd)
  
  how can I get difference value?

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 7 December 2018, 3:09 am EST

  From version 5.20182.524+, PivotFields have support for calculated fields using the getValue property.
  
  Please refer to the following thread reply: https://www.grapecity.com/en/forums/wijmo/calculated-field#this-has-been-added-to-the_2
  
  You may also refer to the following sample: https://jsfiddle.net/jf5so18d/

  ~Sharad