on 03-17-2011 6:55 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
76 | |
9 | |
8 | |
7 | |
6 | |
5 | |
5 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.