Apply Aggregation on Group Dimension Value in Birt Crosstab

prince_iam
edited February 11, 2022 in Analytics #1

Dear Folks,

I am very new to birt, is it possible to apply aggregation on birt crosstab group dimension value. I want to sum the values of one of group dimension and finally display at the bottom row area of crosstab.

Requirement:

Group:

Database Result:

Crosstab Result:

Comments

  • Hi,

    The built-in functionality for generating totals works for the Summary values as you know. To get a total for the group (Dimension), you need to write code similar to the other thread. I attached an example (built in OS Birt).

    Warning No formatter is installed for the format ipb
  • Dear Jeff,
    I am really amazed at your technical skill in birt, particularly javascript. I can't believe this was so simple. You are awesome :smile: Stay Blessed :blush: