Problem with Percentage

[former_member199630]

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

[former_member189638 · Accepted solution]

Try this out.

Create a Formula Key Figure (FKF) and Use The Key figure Net Sales LC in that as below.

FKF = NODIM(Net Sales LC)

Now goto properties of FKF and select Calculate Single Value as Normalize Sub Totals. Tick the checkbox Also apply to results and select Calculate along the Columns from the drop down.

[former_member199630 · Accepted solution]

Thanks Rakesh, good idea.

Regards, Federico

[anshu_lilhori · Accepted solution]

Hi Federico,

Can you please let me know how to paste the output of report on sdn.

Regards,

AL

[former_member199630 · Accepted solution]

Hi Al,

It is not so easy, but it works.

1.- Copy the result of the query.

2.- Paste on the notepad.

3.- Fix the column that you don't see ok tabulating them.

4.- Copy from notepad and paste in the thread.

5.- Mark all the text that you paste in point 4.

6.- Use the "Code button" on the menu.

7.- Post the thread.

Regards, Federico