How to find distinct sum of amount??
Options
Hi All,
i have birt report data like below
Supplier1
order1 ...... 1000
order1 ...... 1000
order1 ...... 1000
order2 ...... 3500
order2 ...... 3500
sum of total 10,000
the sum of total field is agregated on supplier1 field.Total.sum() function in sum of total picking all the values and displaying 10,000.But i want distinct values to be picked for different orders like 1000+3500 = 4,500 should come as sum of total value.
how to achive this.Any help is appreciated.
i have birt report data like below
Supplier1
order1 ...... 1000
order1 ...... 1000
order1 ...... 1000
order2 ...... 3500
order2 ...... 3500
sum of total 10,000
the sum of total field is agregated on supplier1 field.Total.sum() function in sum of total picking all the values and displaying 10,000.But i want distinct values to be picked for different orders like 1000+3500 = 4,500 should come as sum of total value.
how to achive this.Any help is appreciated.
0
Comments
Categories
- All Categories
- 111 Developer Announcements
- 49 Articles
- 103 General Questions
- 123 IM Services
- 40 OpenText Hackathon
- 31 Developer Tools
- 20.6K Analytics
- 4.1K AppWorks
- 8.9K Extended ECM
- 897 Cloud Fax and Notifications
- 77 Digital Asset Management
- 9.3K Documentum
- 29 eDOCS
- 123 Exstream
- 39.8K TeamSite
- 1.7K Web Experience Management
- 1 XM Fax