Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You may add Col4 also as a dimension
use aggr(sum(Qty),Col4) in expression
Refer attached QVW
That is obvious behavior... because values will be suppressed!.. If you want to display both then use Aggr by the 3rd dimension.
HTH
Sreeni
use straight table without aggregate function..
Use Table box
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.