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
Hi,
Try using GetCurrentfield(ABC)
HTH
I have written like this
=if(GetCurrentField($(ABC)),Count(($(ABC))))
but it is not working
Any suggestion???
Does ABC is the variable? If so, Can you elapse that variable expression to understand?
it is ABC is cyclic group name
This simple Field, You meant to say. Correct me if i am wrong.
And, Can you tell me one thing Why you are using $ Symbol here
Perhaps this,
=Count({$<ABC = {"$(=GetCurrentField(ABC))"}>} ABC)
count is showing but when i am take another dimension then count not showing
in this attachment
If i select state GOA from cyclic group and then turn into Brand then it should show me Brand count as lable.
PFA.
You can simply use
= 'Count of Brand'& chr(10)& count(Brand) >>>>>In your Cyclic group Label.
Correct me if I'm wrong. I think you only looking for Counts of Brand