How to find distinct sum of amount??
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
- 108 Developer Announcements
- 53 Articles
- 106 General Questions
- 144 IM Services
- 43 OpenText Hackathon
- 32 Developer Tools
- 20.6K Analytics
- 4.1K AppWorks
- 8.9K Extended ECM
- 899 Cloud Fax and Notifications
- 77 Digital Asset Management
- 9.3K Documentum
- 29 eDOCS
- 120 Exstream
- 39.8K TeamSite
- 1.7K Web Experience Management