en
Welcome Guest! To enable all features please Login or Register.
Options
Go to last post Go to first unread
Steffen Davidsen  
#1 Posted : Friday, January 30, 2015 10:21:23 AM(UTC)
Steffen Davidsen
Rank: Advanced Member

Groups: extranet\Customer
Joined: 7/8/2014(UTC)
Posts: 28

Hello!

A quick question. I wish to create a comparison object. The problem is that the dimension segregating the pie (or bar) chart, contains too many components.
Now, that is easily solved by using comparisons with the two or three top dimension components and a "Others" that contain all other.

The problem is, that the top 3 dimension components may change over time. Is there a way to make this segregation automatically? Say for example, a way to keep the three highest dimension (component) values and then group everything else.

Example:

  • In the first period a firm's top 3 sales are: Jeans, T-shirts and Underwear. Everything else is combined in a category "Other"

  • In the second period a firm's top 3 sales are: Jeans, T-shirts and Sweaters.Sweaters should now take Underwears' place from last period, while underwear will be grouped together with "Others"


I hope it makes sense.

Best regards,
Steffen Davidsen

Edited by user Friday, January 30, 2015 11:16:14 AM(UTC)  | Reason: Not specified

Ole  
#2 Posted : Friday, January 30, 2015 11:01:47 AM(UTC)
Ole
Rank: Administration

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

Hi Steffen,

You may do it with calculations and visibility agents instead of comparisons.

1. Produce a crosstab with all dimension members, e.g. Revenue per Products.
2. Make a descending sort order on the Revenue column.
3. Add a visibility agent, Hide member, with this condition: allcount(d1, d1:0, m1) > 3.
4. Add a custom calculation, calculated row: "Everything else" sum(0, all(h), m1).

Best regards,
Ole
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
Steffen Davidsen  
#3 Posted : Friday, January 30, 2015 11:11:53 AM(UTC)
Steffen Davidsen
Rank: Advanced Member

Groups: extranet\Customer
Joined: 7/8/2014(UTC)
Posts: 28

Originally Posted by: od@targit.com Go to Quoted Post
Hi Steffen,

You may do it with calculations and visibility agents instead of comparisons.

1. Produce a crosstab with all dimension members, e.g. Revenue per Products.
2. Make a descending sort order on the Revenue column.
3. Add a visibility agent, Hide member, with this condition: allcount(d1, d1:0, m1) > 3.
4. Add a custom calculation, calculated row: "Everything else" sum(0, all(h), m1).

Best regards,
Ole


What would I do without you, Ole :-)? It worked perfectly well - thanks a lot!

Best,
Steffen
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