Eclipse Community Forums: BIRT » crosstab

Home » Archived » BIRT » crosstab - summary field as percent

crosstab - summary field as percent [message #248578]

Wed, 18 July 2007 06:54

Eclipse User

Originally posted by: rwojtowicz.dfqs.pl

Hi,
How can I make summary field in a crosstab that has percent of total as a
value?

Re: crosstab - summary field as percent [message #248784 is a reply to message #248578]

Wed, 18 July 2007 21:37

Eclipse User

Hi Rafal

First you should get the total of the summary field:
1, select crosstab and add a aggregation binding named total in binding
page, binding's display filed is measure["each"], and Aggregation on is
all.
2, Drag a dataitem into the summary field of crosstab and input the
expression such as: data["each"]/data["total"].
3, Select the dataitem and format it in Format Number page in Property
editor
4, Choose the Format as Percent
After that you can get all the percent such as xx.xx% in your preview
result.
I don't know whether my description is clear, if any problem let me know.

Regards!

Re: crosstab - summary field as percent [message #248789 is a reply to message #248578]

Wed, 18 July 2007 21:44

Eclipse User

Hi Rafal

Attached report design, hope that will fill what you need

regard!

"Rafal Wojtowicz" <rwojtowicz@dfqs.pl> wrote in message
news:40e15801490db0b03f7af1738dc8af00$1@www.eclipse.org...
> Hi,
> How can I make summary field in a crosstab that has percent of total as a
> value?
>

Attachment: Percent measure.rptdesign
(Size: 73.58KB, Downloaded 596 times)

Previous Topic:	birt runtime 2.2.0
Next Topic:	http status 400 error

Goto Forum:

-=] Back to Top [=-

Current Time: Thu Nov 06 02:55:08 EST 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter