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??
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.