How to show the total nums

[#1]

Hi All,

I found on weird issue on how to show the total nums in the Pivot table:

I have the following records:

load * Inline

[

Nums, Region,Level

1,BR,1

2,BR,2

3,BR,3

]

On the above table, the Region and Level are dimensions field, I put them into Pivot chart as dimension.

And use expressions:  sum(Nums) as A , if(>1,1,0) as C

As you know, there are two dimensions in the Pivot chart, it has collapse and expand sign, when I use expand sign, the C shows the right one, but when I click Collapse, the C shows the wrong one.

Note, the C calculation is based on A expression.

So how to handle it? Please help me out.

I also attached the QVW.

Thanks.

[Anonymous]

what do you expect the column C to show..

according to your condition the calcluated value of A is 6 which is greater than one.. an so the column C shows 1 instead of 0..

[#3]

Thanks for you quick reply.

For now if we expand the dimension, the C shows 0, 1, 1. But when you collapse the dimension, it should show the total nums 2 for C.

Could you open the attached to check it?

[Anonymous]

please check attached..

hope that helps..