en
Welcome Guest! To enable all features please Login or Register.
Options
Go to last post Go to first unread
Morten Nielsen  
#1 Posted : Thursday, August 16, 2018 1:06:17 PM(UTC)
Morten Nielsen
Rank: Newbie

Groups: extranet\Customer
Joined: 7/18/2018(UTC)
Posts: 4

Hi,
I have a sales dataset with customers country and gross sales.

Is it possible to group my customers country in to new categories? Eg. Belgium, Luxemburg and Netherlands to Benelux. Denmark, norway and sweden to Nordic, and so on..

BR.
Morten
Ole  
#2 Posted : Friday, August 17, 2018 6:00:47 AM(UTC)
Ole
Rank: Administration

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

Hi Morten,

Yes. You will use Comparisons/Sammenligninger to do this.

From the Criteria tab on left hand side of the Windows client, add a comparison. In that comparison, add comparison elements, e.g.:

- Nordic = Denmark, Norway, Sweden
- Benelux = Netherlands, Belgium, Luxemburg
- ... = ... etc.

The comparison will probably be added to the horizontal axis of a crosstab at first, but can be moved to vertical axis if preferred. Can even be combined together with your Country dimension on same axis to simulate a hierarchy.

BR / 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
Morten Nielsen  
#3 Posted : Monday, August 20, 2018 8:15:35 AM(UTC)
Morten Nielsen
Rank: Newbie

Groups: extranet\Customer
Joined: 7/18/2018(UTC)
Posts: 4

Thanks Ole, it worked like a charme.

However, I have created an Other element where the rest of the countries are in. Is it possible to show these specific countries in the same crosstab if the row Others is selected?

BR/ Morten
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.

ok