Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You can try this:
='Count -> ' & Count(DISTINCT $(='['&GetCurrentField([New Group]) & ']'))
@sunny,
I need Dimension label also means when i do cyclic group as brand then it should display Brand > Count > 14 as Label.
Thanks
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.
Any advice??
Any advice on what my friend? I think I missed the question in your previous post?