Skip to Content
0
Former Member
Jan 09, 2008 at 03:44 PM

Count of no of line items in the report

210 Views

Hi All,

I have the following reporting requirement.Can anybody please provide me the solution.

Data in the cube

User id Accounting Doc No Lineitem Amount

abc1 10001 001 100

abc1 10001 002 100

abc1 10001 003 100

abc2 10002 001 1000

abc2 10002 002 1100

abc1 10003 001 100

Requirement:

The report output shuold look like this

User id No of Accounting Docs Total no of Lineitem count Amount

abc1 2 4 400

abc2 1 2 2100

I got the count of No of accounting documents.For lineietms I am unable to Get the count.

The system is version BI7.0

Thanks for your time.

Srinivas