Group Total Divided by Grand Total

Group Total Divided by Grand Total

Posted by: bnguyen on 11 January 2024, 4:36 am EST

• 

  bnguyen

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 11 January 2024, 4:36 am EST - Updated 11 January 2024, 5:36 am EST

  EDIT: I have figured it out by using the aggregate with SCOPE pointing towards the dataset. How can we use scope for things other than the dataset?

  I have a table with detail grouping by column A. Is it possible to have a detail section with (A_1 / TOTAL_A), (A_2 / TOTAL_A) … (A_N/TOTAL_A) through an expression using only 1 data set?

  In other words, can we get the grossed value of each column with one data set or do we require another? (Group Total) / (Grand Total of all Groups).

  I am unable to get the grand total of all the groups to divide each row by.

• 

  akshay.rajput

  

  • Post Options:
  • Link
    Copy

  Posted 11 January 2024, 9:34 pm EST

  Hi Bryan,

  I am glad to know your issue is resolved. You can add scope to almost all of the Aggregate Functions. For more information on Expressions, Aggregate Functions and Scope, please refer to the following page of our documentation: Expression