Help regarding Cyclic Group

[nikhilgarg]

Hello,

I ahve cyclic group having dimensions as : Area Manager and Customer Name

. I want in my chart title, it should show Top 'N' Area Manager or Top 'N' Customer dynamically when i choose area manager or customer from cyclic group.

Plz help

[tamilarasu]

You want to show top N Manager Name / Customer Name.?

Try something like below,

Concat(Aggr(If(RANK(Sum(Sales))<N,"CylicGroupName"),"CylicGroupName"),',')

[mightyqlikers]

hi

use dimension limits.

Regards

$@M.

[mightyqlikers]

hi

use getselectedfield or getpossiblecount fuctions

Regarsd

$@M.

[Anonymous]

Say, Your Dim is: Cyclic Group

expression:  Sum(Sales)

Then Goto -> Sort Tab -> Expression i.e Sum(Sales) -> Ascending or Descending( As required by you)

Note: Dont Forget to untick all other option for Cyclic Dim, Tick Only Expression only

After that:

Presentation -> Top Right(Tick Enable X axis Scroll bar) -> Item Exceeds Limit -> 5

This will give you top 5 only

[#6]

I am assuming you are only talking about the title as differing between "Area Manager" and "Customer".

Fieldvalue('Name of cyclic group') will return this.
If your cyclic group is called C_GROUP and you are currently displaying the field [Customer] (in C_GROUP),

FieldValue('C_GROUP') will return "Customer".

So combine that in the title -> ='Top N (whatever number you like) ' & FieldValue('C_GROUP').

If this is regarding the 'N' as denoted, that depends on what rules you want to apply for showing the top N's. Dimension limit often does the trick.

[#7]

'fieldvalue' is a two parameter function.

Tried implementing what you said but wasnt working..

[jonathandienst]

That should be =GetCurrentField('groupname')

(I have had problems in the past with this function with groups with spaces in the name)

[#9]

Use the getcurrentfield function to modify the Chart Title.

='Top N ' & GetCurrentField('CyclicGroupName')

If you want to show only Top N , use dimension limits on your first expression.

[nikhilgarg]

Hey,

I also have space in fieldnames in CyclicGroup. How to resolve that?