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!

Find more posts tagged with

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 Dodson

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>