'Show partial sums' when using conditionals

[#1]

Hi,

I have a pivot table which has Properties-->General-->'Calculation Condition' and also Properties-->Dimensions-->'Enable conditional' and also Properties-->Expressions-->Conditional.

The problem is that I need totats for the expressions shows but when I try to use Properties-->Presentation-->'Dimensions and Expressions'-->'Show Partial Sums'(check box) this check box is not available for any dimension and expression.

Is there other place in properties or alternative solution to get totals in this 'complex' pivot table??

Thanks

[MayilVahanan]

HI

Please post a sample file, so that, we can able to find the solution,.

[Anonymous]

Sample?

[Digvijay_Singh]

Partial sum is available for Dimensions only in pivot tables, which means it will subtotal the expressions for the checked Dimension level. I don't think adding conditions should make the difference in that. See the sample attached and see if you can recreate the problem.

[#5]

See the attached,

the pivot table is 'Balance' , by the way I wonder why I am not able to see the dimension DescEpig2 enterely.

Thanks

[#6]

Maybe the problem is other anyway I am looking for the total column.