Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
find_total
BUBU
hII ALL,
SUPPOSE I HAVE A DATASET IN DETAILS ROW ORDERCOST AND I WANT TO FIND OUT TOTALING OF TIS COLUMN IN BIRT REPORT DESIGN.PLEASE HELP ME..
IN PREVIEW THE DATAZ COMING LIKE THAT
ORDERCOST
23
34
30
TOTAL 87
Z LIKE THAT.
Find more posts tagged with
Comments
mwilliams
In the footer of your table, drag in an aggregation from the "palette" or right-click in the footer cell and choose Insert -> aggregation. Choose the "SUM" function and use the expression row["columnName"]. That should do it.
SarahJacob
Michael, that's a great function. But do you know how to aggregate loads of columns at a time. Say I have ten columns of data that each need an aggregate at the bottom/footer. Is there a way to do it besides individually? It's very time consuming. Thanks.
mwilliams
In a standard table, you'll have to do them each individually since the columns are not dynamic. If you were able to use a crosstab for your setup, you could add a total row since the columns are created dynamically.