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!
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.
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.
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.
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.
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.
For some reason it doesnt work at all when you try just a simple formula as:
I give up, and I'll just put the column in the first column, so even if you expand(Member and children) the last column, you'll keep the "Variation %" column just next to the other two column.