Problem with Percentage

Hi All,

We are faceing an issue with the percentage. I am using the %CT.

If I define the query with the following drill (Calendar Month and Sector in Rows) it works.

				Net Sales % LC (%CT)	Net Sales LC
Calendar Year/Month	Sector	%			ARS
03.2007			01	89,41			6.675.488
			02	10,59			790.698
	Result			54,04			7.466.187
04.2007			01	91,07			5.783.825
			02	8,93			567.291
	Result			45,96			6.351.116
Overall Result			100,00			13.817.303

But if I put the Calendar Month in Columns, the percentage are showing an X.

Calendar Year/Month	03.2007					04.2007					Overall Result	
			Net Sales % LC (%CT)	Net Sales LC	Net Sales % LC (%CT)	Net Sales LC	Net Sales % LC (%CT)	Net Sales LC
Sector			%			ARS		%			ARS		%			ARS
01			X			6.675.488	X			5.783.825	90,17			12.459.314
02			X			790.698		X			567.291		9,83			1.357.990
Overall Result		54,04			7.466.187	45,96			6.351.116	100,00			13.817.303

We need the Month in columns, and the layout should be:

Calendar Year/Month	03.2007					04.2007					Overall Result	
			Net Sales % LC (%CT)	Net Sales LC	Net Sales % LC (%CT)	Net Sales LC	Net Sales % LC (%CT)	Net Sales LC
Sector			%			ARS		%			ARS		%			ARS
01			89,41			6.675.488	91,07			5.783.825	90,17			12.459.314
02			10,59			790.698		8,93			567.291		9,83			1.357.990
Overall Result		54,04			7.466.187	45,96			6.351.116	100,00			13.817.303

I have tried the other percentage, but they use the Overall Result (month and Sector) and we need the pertentage depending on the result of the Sector.

I appreciate other solution also.

Regards, Federico