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 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.
Aaron0 -
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>Warning No formatter is installed for the format ipb0
Categories
- All Categories
- 107 Developer Announcements
- 53 Articles
- 106 General Questions
- 142 IM Services
- 43 OpenText Hackathon
- 32 Developer Tools
- 20.6K Analytics
- 4.1K AppWorks
- 8.9K Extended ECM
- 898 Cloud Fax and Notifications
- 76 Digital Asset Management
- 9.3K Documentum
- 29 eDOCS
- 118 Exstream
- 39.8K TeamSite
- 1.7K Web Experience Management