How to display record not in sum group by cust code in WebI?

building reports webintelligence
1

Hi,

I have a simple universe, consist of cust_code, sales_quantity.

In database, the data will look like this
<Sales_Quantity>
C01…1
C01…2
C01…2
C02…4
C02…4

I want to create a we intelligence report using this universe.
But when i preview the report, it has group the cust_code for me.
<Sales_Quantity>
C01…5
C02…8

Anyway this report can display as what i want in the database table?

In universe,
Cust Code is dimension, Sales_Quantity is measure…

Thanks!

ylai20 :malaysia: (BOB member since 2008-05-21)

2

Check the check box ‘Avoid Duplicate Row Aggregation’ and see if it works.

Jansi :india: (BOB member since 2008-05-12)

3

Yes, it works!
Thanks a lot!

ylai20 :malaysia: (BOB member since 2008-05-21)

4

Glad it worked. :smiley: [Moderator Note: Moving to Web-XI - Jansi]

Jansi :india: (BOB member since 2008-05-12)