percentage of parent column total - without using the column

Hi,

i have the following pivot table:

Pivot 1
jan/14 feb/14 mrt/14
row yes no yes no yes no
1 3 2 3 2 3 2
2 0 5 3 2 3 2
total 3 7 6 4 6 4

Using the function 'show values as % of parent column total', i get the following result:
for row = 1 and date = jan/14, 60% is the calculation of 3 / ( 3 + 2 ), and so on

Pivot 2
jan/14 feb/14 mrt/14
row yes no yes no yes no
1 60% 40% 60% 40% 60% 40%
2 0% 100% 60% 40% 60% 40%
total 30% 70% 60% 40% 60% 40%

Is it possible to show the pivot table as pivot table 2, but without the no column, as if the no column was hidden, just as pivot 3
If the yes value equels 60%, well then it is quite logical that the no value equels 40%...


Pivot 3

jan/14 feb/14 mrt/14
row
1 60% 60% 60%
2 0% 60% 60%
total 30% 60% 60%


My actual pivot table is quite bigger and complexer, so it would help a lot if i could just 'hide' the no value colum.

i have uploaded a sample file just if the above is not clear.

thanks.

Yes we do.
Thanx

hi, this doesn't seem to work with me, I can't enter your All_X_Sum formula, error: [X_Sum] cannot be found.
If I just enter YesPct = SUM(Table1[x]) / CALCULATE([X_sum],all(Table1[op tijd])), I get an circular reference error.
I don't really understand what I am doing wrong.

Off course, what i did
However, i got the error

enclosed the file, with the errors.
thnx.

we use excel 2010, don't really know what you mean by measure / column.

Alright! thank you, just what i was looking for.
thnx.