Cyclic group count

[Anonymous]

Dear All,

I have used one cyclic group called "ABC" in pivot table and it has 10+ dimension like Country , State , City etc... .

I want whenever user select any dimension then dimension count will be seen as Label .

Exp: If user select country say India in ABC group and change to city then it should display count of city which is present in India in label.

Thanks

[sunny_talwar]

You can try this:

='Count -> ' & Count(DISTINCT $(='['&GetCurrentField([New Group]) & ']'))

[Anonymous]

@sunny,

I need Dimension label also means when i do cyclic group as brand then it should display Brand > Count > 14 as Label.

Thanks

[Anonymous]

Hi Sunny,

It will showing me all dimension count

I have four charts Zone wise if I select one division in West Zone chart and after i do cyclic to state / product or etc dimension then it is showing me all count

PFA.

[Anonymous]

Any advice??

[sunny_talwar]

Any advice on what my friend? I think I missed the question in your previous post?