Calculated column in crosstab

Hi,
I am using birt 2.3.1. i have three column in data set like time,industry and count.
I need to show values of industry column as table heading in my report.
suppose i have three industry 'A' , 'B' and 'C'.
so the report will be like:

'A' 'B' 'C'
2008(Q1) 12.3% 34.8% 52.9%

So for thisi used crosstab.
I took time and industry as dimension and count as summary field.
Then in crosstab i did grand total using column area tab.
by deviding summary field with grand column i calculated percentage, but when i changed view as chart view in series birt is not showing Percentage field.

is there any way to calculate the percentage?

Thanks in advance.

Regards,
Sumit

Find more posts tagged with

Comments

mwilliams

Hi Sumit,

Can you recreate your issue with the sample database so I can see exactly what you're doing and what you're seeing? I'll try to recreate it myself in the meantime using your description above.

SumitSingh

Thanks Michael.

Suppose i have following dataset:

time department count
2008(Q1) Adimn 24
2008(Q2) Admin 46
2008(Q1) Management 56
2008(Q2) Management 50
2008(Q1) Finance 34
2008(Q2) Finance 76

I have following data in my crosstab.
Admin Management Finance
2008(Q1) 24 56 34
2008(Q2) 46 50 76

But I want Percentage instaed of count something like:

Admin Management Finance
2008(Q1) 21.05% 49.12% 29.82%
2008(Q2) 26.74% 29.06% 44.18%

so i took grand total on row basis and devied each count with this grand total.

mwilliams

Sumit,

Without having the total for the time period in your dataSet, I don't see a way to get the percentage into a chart rendering. The chart will only use the actual measure value when it shows as a chart. I'll look at this in the newer versions of BIRT as well and I'll let you know if anything has changed.

SumitSingh

Hi,

Thanks a lot for your reply.

As you said "The chart will only use the actual measure value when it shows as a chart".
So is there anyway to show percentage in Graphs.

--Sumit

mwilliams

Sumit,<br />
<br />
It looks like you'll have to get the percentage figured prior to the crosstab to get it included in the chart. Off the top of my head, I can't think of anything to do to work around this. You can request an enhancement along these lines at <a class='bbc_url' href='http://www.birt-exchange.org/bug-reporting/'>Report Bugs - BIRT Exchange</a> for a crosstab measure to be calculated as a percent of row or column total.