Pivot Table partial Sums for conditional dimensions

[#1]

We have a pivot table with Conditional dimensions. We want to enable partial sums for only 4 dimensions. But since all dimensions are conditional and partial sums are based on the next columns its causing issues. If we hide the column with partial sum enabled, the previous column doesn't show partial sum. Any idea on How to make the partial sum constant on the 4 dimensions irrespective of which other dimensions are selected?

[sunny_talwar]

Would you be able to share a sample to show your issue? May be also provide the expected output?

[#3]

Hi,

We have a pivot table as shown below where we have many dimensions. All the dimensions are conditionally enabled.

The below 4 should always have Subtotals as shown below. They can also be hidden. We can add more dimensions which don't have subtotals enabled. When they are added in between any of the below columns, the Subtotals for these columns will not show as they will not have subtotals enabled.

Is there a way to always show subtotals only for the below 4 columns irrespective of new dimensions added?

Dim 1	Dim 2	Dim 3	Dim 4	Expr1
-	-	-	-	18674469.869098
			Total	18674469.869098
		Total		18674469.869098
	Total			18674469.869098
Total				18674469.869098

[sunny_talwar]

I am still not sure what you might be looking to get. Would you be able to share a qvw where you are trying this?