Problem with Duplicate Row

[Anonymous]

Hi,

I have a question about showing duplicate Row.

I have a Data like this:

Col1          Col2          Qty           Col4

A               B              10               D

A               B              10               E

The problem is when I create  a pivot table with 2 dimension(Col1 and Col2) with the expression Sum(Qty)

There is only one row shown, the result i expect is both row is shown in my pivot table ?

Do you know how to solve this problem ?

Thanks

[nagaiank]

You may add Col4 also as a dimension

[#3]

use aggr(sum(Qty),Col4) in expression

[#4]

Refer attached QVW

[SreeniJD]

That is obvious behavior... because values will be suppressed!.. If you want to display both then use Aggr by the 3rd dimension.

HTH

Sreeni

[Anonymous]

use straight table without aggregate function..

[Kushal_Chawda]

Use Table box

[santhosh_k_n]

Hi,

I could say unless you present the col4 you will get single row, try using the Col4 in the pivot table and hide the cloum.