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; } } }

Group Sum of visible Groupdetails on Page

ThomasPz

Hello,
 
I want to display group sums in Group Header. The Header should repeat, if a page break in the group is neccessarry. Is there a way, that birt could only sum the visible entries on the page and not the whole sum of the group?
I couldn't count the lines, because the content in some cells could create a line break if it is to long. So I couldn't define how many lines are normally possible on one page.
 
Example:
 
The Data is like this:
<pre class="_prettyXprint">
My Group
a) My Content 10
b) My Content 20
c) My Content 30
d) My Content 40</pre>
Let's say the page breaks between b and c. Then I need this result:
 
on Page 1:
<pre class="_prettyXprint">
My Group Sum=30
a) My Content 10
b) My Content 20
</pre>
on Page 2:
<pre class="_prettyXprint">
My Group Sum=70
c) My Content 30
d) My Content 40</pre>
<div>I can only generate this result:</div>
<div> </div>
<div>
on Page 1:
<pre class="_prettyXprint">
My Group Sum=100
a) My Content 10
b) My Content 20
</pre>
on Page 2:
<pre class="_prettyXprint">
My Group Sum=100
c) My Content 30
d) My Content 40</pre>
Is there a way to Sum only the visible content rows in group, without line counting?
 
</div>

Find more posts tagged with

Comments

shamo

Try two aggregations . First is sum based on the group then a second aggregation on your first aggregation with the first function. Hope it helps