OLAP: Calculate PctCol by subtotal instead grand Total

OLAP: Calculate PctCol by subtotal instead grand Total

Posted by: subakaranmca on 18 June 2019, 3:16 pm EST

• 

  subakaranmca

  • Post Options:
  • Link
    Copy

  Posted 18 June 2019, 3:16 pm EST - Updated 3 October 2022, 10:59 am EST

  Now, PctCol is calculated against of GradTotal. I want to calculate by subTotal

  Please refer attached screen. Expected result is in Red color

  

  516×578 106 KB

• 

  abhishek.dutta

  

  • Post Options:
  • Link
    Copy

  Posted 19 June 2019, 9:08 pm EST

  Hello,

  There isn’t an enum for calculating percentage using subtotal of the column so you will have to create your own calculated field. Please refer to the sample below:

  https://jsfiddle.net/j2ufp3rm/