Home
Designing Analytics Reports
Crosstabs
adouglas
I have a fairly simple crosstab that I need created. It has a two dimensions, product on the left and company on the top. I have the sales amount as a sum measure but now I need another measure immediately next to it that shows the percentage of total for that product for that company. The group footer will show the total sales and then 100% for the percentage of total.
I'm using Birt 2.2.1.
Any help would be greatly appreciated!
Find more posts tagged with
Analytics
reports
#BIRT
Comments
adouglas
I did some digging and I eventually got it to work.
I had to add the same field I wanted a percentage of again to the cube. I named it Percent. Then I modified the data binding of the percent field to be the field / field aggregated over the company.
Seems to work except I need to fix the percent total in the group footer.
Aaron
Virgil
Hi Aaron,<br />
<br />
You should be able to delete the group total in the footer and just add a label that says "100%". I had to create a simple example to try this myself so I uploaded it to the DevShare at <a class='bbc_url' href='
http://www.birt-exchange.com/modules/wfdownloads/singlefile.php?cid=2&lid=207'>http://www.birt-exchange.com/modules/wfdownloads/singlefile.php?cid=2&lid=207</a>
;