The community of Analytics developers are invited to follow and participate in the developer network.
OpenText technical experts collaborate with supported customers and partners in the Magellan product area.
OpenText technical experts collaborate with supported customers and partners in the Magellan product area.
Crosstabs & Percentage Of Measure

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!
I'm using Birt 2.2.1.
Any help would be greatly appreciated!
0
Comments
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
<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>
Virgil Dodson
OpenText Analytics Developer Community
https://forums.opentext.com/forums/categories/analytics