en
Welcome Guest! To enable all features please Login or Register.
Options
Go to last post Go to first unread
Michael Eget  
#1 Posted : Tuesday, July 7, 2015 9:22:53 AM(UTC)
Michael Eget
Rank: Advanced Member

Groups: extranet\Forum
Joined: 2/20/2014(UTC)
Posts: 11

Hi all,

I've got a problem when trying to count the number of entries of a given dimension value.

My situation is that I want a bit marker every time the Salesperson is "Keren Rose", I can implement it when I don't sort data by Period.
But as soon as I sort data by Period (right know just by monthname) it doesn't work.

The picture shows my calculations, that are gonna be inserted into an if statement to determine when they equal.
The top picture is the scenario i want, but where the formulas don't work. The bottom is when not sorted and it works.

UserPostedImage

Can anyone please help?

Thanks in advance

Michael
Páll Bjarkason  
#2 Posted : Tuesday, July 7, 2015 8:45:53 PM(UTC)
Páll Bjarkason
Rank: Advanced Member

Groups: extranet\Forum
Joined: 1/13/2012(UTC)
Posts: 164

Hi Michael

Have you considred the "unsorted" operator on the 2nd parameter?

Edited by user Tuesday, July 7, 2015 8:46:59 PM(UTC)  | Reason: Not specified

Best regards

Páll, CTS
Michael Eget  
#3 Posted : Wednesday, July 8, 2015 6:10:22 AM(UTC)
Michael Eget
Rank: Advanced Member

Groups: extranet\Forum
Joined: 2/20/2014(UTC)
Posts: 11

Hi Páll,

Yes I did try using "u" instead of "n". Then the formula would be like:
allcount(d1, d1:@"[Keren Rose]"(l(1,0),u), m1).
But unfortunately that doesn't do the trick.

It can easily be done with only one dimension on the y-axis, but that cannot be used in this scenario here.

Looking forward to see if anyone can solve this.

Best regards
Michael
Páll Bjarkason  
#4 Posted : Thursday, July 9, 2015 5:28:43 PM(UTC)
Páll Bjarkason
Rank: Advanced Member

Groups: extranet\Forum
Joined: 1/13/2012(UTC)
Posts: 164

Hi Michael

Try, right click on the month column and select “table -> sorting -> hierarchical collation” then the names in the first column should be grouped like in the picture below.
Hopefully you can get some inspiration...

UserPostedImage
Best regards

Páll, CTS
Michael Eget  
#5 Posted : Monday, July 13, 2015 8:07:27 AM(UTC)
Michael Eget
Rank: Advanced Member

Groups: extranet\Forum
Joined: 2/20/2014(UTC)
Posts: 11

Hi Páll,

I did try that, and it is correct then the formula works, but I don't want the hierarchical sorting.
I left out one dimension of my axis, so it is no longer nested and there much easier to solve.

Thanks,

Best regards
Michael
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