en
Welcome Guest! To enable all features please Login or Register.
Options
Go to last post Go to first unread
Lotte Bjørn Jensen  
#1 Posted : Thursday, December 13, 2012 2:50:22 PM(UTC)
Lotte Bjørn Jensen
Rank: Advanced Member

Groups: extranet\Forum
Joined: 4/8/2011(UTC)
Posts: 68

Hi

How do I count members of a dimension?
I've tried with this: allcount(d1,all(c),m1), but it returns 0.

I would like to know how many members there is in "Netto", but I don't want to see the members.

UserPostedImage

Regards
Lotte
Best regards

Lotte Bjørn
Daniel  
#2 Posted : Friday, December 14, 2012 1:17:31 PM(UTC)
Daniel
Rank: Advanced Member

Groups: extranet\Forum
Joined: 11/29/2012(UTC)
Posts: 18

Hi Lotte,

Your calculation seems to be correct. From what I've seen, I think that should work if you show Subtotals ?
Look at this screenshot without Subtotals and another with Subtotals:

UserPostedImage

UserPostedImage

Regards,
Dani
Ole  
#3 Posted : Friday, December 14, 2012 1:30:42 PM(UTC)
Ole
Rank: Administration

Groups: extranet\Forum
Joined: 4/7/2011(UTC)
Posts: 320

Hi Lotte,

You will need to use subtotals, as mentioned by Dani.

In order to not "to see the members" you will also need to apply a visibility agent.

See screenshot.

BR / Ole

UserPostedImage
I work as an employee with TARGIT A/S. Any statement made by me in this forum represents my own opinion and state of mind, and is not necessarily related to or representative of TARGIT A/S.

UserPostedImage Ole Dyring
Lotte Bjørn Jensen  
#4 Posted : Friday, December 14, 2012 3:12:32 PM(UTC)
Lotte Bjørn Jensen
Rank: Advanced Member

Groups: extranet\Forum
Joined: 4/8/2011(UTC)
Posts: 68

Thanks, both of you.

Now it works.

Lotte ;-)
Best regards

Lotte Bjørn
Users browsing this topic
Anonymous
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Notification

Icon
Error