on 04-10-2012 12:33 PM
Hi!
I have a report with three columns, lets call them: "Real", "Budget" and "%"(local member). The last one is basically "Real/Budget". Thing is, I want to set this last column as the second column in my report so I will have "Real", "%" and "Budget", but in the Sorting tab of the Report Editor you can't actually select a Local Member in the Sorting Criteria, only the other two. Thus, the order will be "Real", "Budget" and "%".
Any ideas/workarounds? Thanks in advance!
Hi Lago,
I am guessing Real and Budget are the categories. If yes, are these going to be constant? If yes, then you don't need any expansion on the columns. In that case, you can just hardcode them as per your desired sequence. Even if they are not static, you can use multiple expansion in the column using the "|" operator. Keep one column empty in between, and put the formula for % in that column.
Hope this helps.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Nilanjan,
Yes, Real(Actual in the picture) and Budget are CATEGORY members, although Budget(Presupuesto v1 in the picture) won't be static, that's why I want it to be on the right side. Thing is, I insert an empty column between both categories, and put the % (% Variación in the picture) formula.. but after refreshing, it keeps moving the Budget (Presupuesto v1) next to the Actual one.
Hi Iago,
I'm not sure I've understand your problem but if you want mantain the expansion on the "% Variacion" column you may just add 2 empty columns right side of the % in the ColKeyRange changing the EVRNG, f.e. from "=EVRNG(G14:H14)" to "=EVRNG(G14:H14; J14:K14)" leaving the J14:K14 cells empty, so even the % will be expanded.
Kind regards
Roberto
Hi Roberto,
Thanks for your answer, but no, the "% Variacion" is not going to be expanded. "Presupuesto v1" will be expanded, thats why I want it on the right column. And the column "% Variacion" (the formula is "Actual/Presupuesto v1 %", basically) in the middle.
Looking at the picture, what I want to do, is basically, swap "Presupuesto v1" for "% Variacion" column. But when I do it, and then refresh the workbook, it keeps going back to the position shown in the picture.
Kind regards,
Iago.
Hi Lago,
What you need to do is to modify the colkeyrange.
For example, if your colkeyrange is "=EVRNG(G14:H14)". Please change it to "=EVRNG(G14:H14; J14:K14)". And you expansion should be something like ACTUAL|PRESUPIESTOV1.
With this technique, you are breaking the column expansion in 2 parts. First expansion will take place from G to H with ACTUAL, and the second expansion will take place from J to K for PRESUPIESTOV1. Now, you will get 1 blank column in the middle - column I. Place your formula in this column.
Hope this helps.
Hi Iago,
You are on a version SP05 + patch 3 = 10.0.0.7143 SAP NOTE 1653310
See Note 1366676 (at the bottom) to determine what version you are on.
I would upgrade to the latest version which is SP08 Patch 4 SAP Note 1707187
Thanks,
John
User | Count |
---|---|
15 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.