en
Welcome Guest! To enable all features please Login or Register.
Options
Go to last post Go to first unread
Elin Petersen  
#1 Posted : Monday, November 6, 2017 9:37:53 AM(UTC)
Elin Petersen
Rank: Advanced Member

Groups: extranet\Forum
Joined: 6/26/2012(UTC)
Posts: 18

Hi.

I would like to build a toplist within a hierarchy. Is that possible?

So, for example, I have 3 Platforms: A, B and C. Within these platforms I have various material numbers. I want to see for every platform the Top 5 products by sold qty. Now I have made for each platform one table. Can I get this all in one?

Best regards
Elin
Elin Petersen  
#2 Posted : Monday, November 6, 2017 11:53:35 AM(UTC)
Elin Petersen
Rank: Advanced Member

Groups: extranet\Forum
Joined: 6/26/2012(UTC)
Posts: 18

I solved it on my own. :)

C1:
count(c2, d1:0(l(1,0)), m1)

C2:
sum(all, 0, m1)
(This is necessary because I also want to see it over regions)

C3:
if sum(c1, 0, 0) <> sum(c1, -1, 0, 0) then sum(all, 0, m1) else if sum(c1, 0, 0) <> sum(c1, -2, 0, 0) then sum(all, 0, m1) else if sum(c1, 0, 0) <> sum(c1, -3, 0, 0) then sum(all, 0, m1) else if sum(c1, 0, 0) <> sum(c1, -4, 0, 0) then sum(all, 0, m1) else if sum(c1, 0, 0) <> sum(c1, -5, 0, 0) then sum(all, 0, m1) else 0

And then:
Visibility Agent on c3 = 0
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

We use cookies to improve your site experience, but they also provide us with information on your use of our website.
To find out more about the cookies we use and how to delete them, see our Privacy Policy. By continuing to browse the site, you are consenting to our use of cookies.