nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to acheive report as displayed in attached image

bokya

Hi BIRT Guru,

Can you please guide me how to design report which i attached below.
I want to have sum of both groups as well as sum of each row which i clearly mentioned in attached image.

Bottom 5 rows are footer row to have sumation of "ABC" and "XYZ".

Find more posts tagged with

Comments

kclark

You can add another aggregation item from the pallet to the table footer bellow the group footer. Then you can aggregate by the table footer sums or write another expression from the expression builder. I've attached an example. Let me know if this helps.

bokya

Thanks Kclark,

But is it possible to achieve it dynamically. It means, now details row value are "CC,PR,TR,ZR" so total footer row will be four for each of the Value. Now suppose if there are only two value "CC,PR" then how do i add footer dynamically according to details row?

bokya

Please somebody reply,

johnw

The easiest way that I see is to have a single data set:

Variety
Type
WhateverValueIsBeingAggregated

Create a table with grouping on Variety and on Type

Create Aggregation on the level of Variety and Type, giving the individual Count

Create Aggregation with only the Type level, giving total without taking Variety into account.