OLAP: Calculate PctCol by subtotal instead grand Total

OLAP: Calculate PctCol by subtotal instead grand Total

Posted by: subakaranmca on 19 June 2019, 12:16 am EST

• 

  subakaranmca

  • Post Options:
  • Link
    Copy

  Posted 19 June 2019, 12:16 am EST - Updated 3 October 2022, 7:59 pm 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 20 June 2019, 6:08 am 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/