Dynamic title when cyclic group is selected

[#1]

Hello,

i have few question regarding cyclic group.

1. The cyclic group always shows static title like the following. says if i have 2 selections - "Month", "Year", how can i make the title in this case - "Type" change accordingly to "Year" / "Month" ?

2. How can i position it from left top to right-bottom?

3. how can i create a dynamic title for my chart? i needed something like "Total Sales by <Month / Year>"

Thanks,
Nick

[#2]

ok, i did Qns 3 like..

=

if(GetCurrentField(TotalLeadTime)='CreaMonth','Month', 'Market') &' (Target = 28 days)'

and now i have another problem... i'm able to include additional strings at the end of the formula using & ' abc ' , but how can i do the same for the front?

it doesn't work if i do this 'Total by'& =if(GetCurrentField(TotalLeadTime)='CreaMonth','Month', 'Market') &' (Target = 28 days)'

[#3]

ok, here is the answer for Qns 1, just have to uncheck the LABEL box in DIMENTION tab. :]

[#4]

To change the position of you cyclic button push CTRL + SHIFT Button, then you'll see red squares in your chart, allowing to move some items.

[sparur]

Hi,

try that:

'Total by'& if(GetCurrentField(TotalLeadTime)='CreaMonth','Month', 'Market') &' (Target = 28 days)'

Qns 2: it's impossible, as I Know

[#6]

Hi,

Yeah, it's not possible. i can see the red square, but it wont move the cyclic to anywhere.

for the formula, i did try that too, but it's not working either.

the problem is, you can't have anyhting, not even a space, in front of the "=" sign, otherwise the whole formula wont work. it's weird....

[#7]

Hi Nick

On Question 2, I agree with Spastor that you should use CTRL-SHIFT, keep those buttons held down, use the mouse to drag & drop the cyclic group title where you want. I use this all the time, I just used it on another object and it worked with no problem at all.

Not sure which formula you are referring to when you say its not working, but if it's the title formula suggested above, just try putting an = sign at the left side of that formula.

[#8]

Still.... the CTRL+SHIFT doesnt work. i can move the title and legend to wherever i want, but not the cyclic, i don't know why.

for the formula if i do this > "=if(GetCurrentField(TotalLeadTime)='CreaMonth','Month', 'Market') &' (Target = 28 days)'" it works and will return > Market (Target = 28)

but i wanted to do this > Chart by Market (Target = 28)
If i put a space infront of the equal sign, it wont work > " =if(GetCurrentField(TotalLeadTime)='CreaMonth','Month', 'Market') &' (Target = 28 days)'" it wont work, meaning, i can't even put anything in before the equal sign, i tried many ways.. like " 'Chart by'&=if(GetCurrentField(TotalLeadTime)='CreaMonth','Month', 'Market') &' (Target = 28 days)'"

As long as i put anything infront of the equal sign, it returns the formula as string to me as a whole.

Any other solutions ?

[#9 · Accepted solution]

I have no idea why the CTRL-SHIFT does not work!!

For the formula.....

= 'Chart by ' & IF(GetCurrentField(TotalLeadTime)='CreaMonth','Month','Market') & ' (Target = 28 days)'

[#10]

AH HA ! why didn't I think of that.... lol.. it works perfect now ! Thanks.

As for the cyclic, i think it must be that particular chart, cos the other works fine.

Thanks for the help.