8 Replies Latest reply on Jul 5, 2017 10:19 AM by andwu

Show rank of my company within each category

andwu Jul 4, 2017 1:23 AM

Hi,

i'd like to build a report with several columns (market sales current year, market growth to previous year etc.) with one row per Category. One of the columns should show the Rank of my Company within this Category. E.g. in Product Category 1 I'm on position 2, in Category 2 I'm on position 4. Is there any smart way to do this in one report?

I have attached a simple twbx file.

Thanks a lot,

André

Examply Rank of Company within each Category.twbx 16.9 KB

1. Re: Show rank of my company within each category

T G Jul 4, 2017 1:39 AM (in response to andwu)
Hello Andre,

Refer the below snapshot. If this is you are looking at then you just need to create a calculated field Rank = Rank(SUM([Sales])). But, result given by you is not the same. But as per view, its correct. Workbook is also attached.

Change the table calculation of Rank like as below.

TG

Examply Rank of Company within each Category.twbx 35.1 KB
Like Show 0 Likes(0)

Actions
2. Re: Show rank of my company within each category

andwu Jul 4, 2017 5:04 AM (in response to T G)

Hi T G.,

this is close to what I need. I do not want to see the competitors in the rows, just "my" position in the appropriate category.

E.g.       Category        Market Sales          My Sales          My Position
               1                    132486               1535                    7
               2                    564678               98623                  2
.........

Hope that helps to follow my problem.

Thank you for your effort
Like Show 0 Likes(0)

Actions
3. Re: Show rank of my company within each category

T G Jul 4, 2017 5:19 AM (in response to andwu)
Hello Andre,

Just remove the corporation and create a calculated field as Rank(SUM([Sales])). Update workbook is also attached.

Examply Rank of Company within each Category.twbx 14.2 KB
Like Show 0 Likes(0)

Actions
4. Re: Show rank of my company within each category

andwu Jul 4, 2017 10:49 PM (in response to T G)

Hi, the result shows the overall ranking of the categories, but not the ranking of "My corporation" within each category.

Therefore I would assume to use a calculated field like:

If [Corporation] = "My corporation" THEN
{ Include [Corporation] : RANK(SUM([SALES]))}
ELSE
0
END

But I do get the error, that Include is not possible for ATTR functions.

Any idea?

Thanks
Like Show 0 Likes(0)

Actions
5. Re: Show rank of my company within each category

T G Jul 4, 2017 11:23 PM (in response to andwu)
Hello Andre,

Sorry may be i am struggling to get your requirement. You want My Corporation rank in each category and don't want to show corporation in the View. If this is correct, refer the below snapshot and attached workbook.

TG

Examply Rank of Company within each Category.twbx 47.2 KB
Like Show 1 Likes(1)

Actions
6. Re: Show rank of my company within each category

mara.quindoza Jul 4, 2017 11:44 PM (in response to andwu)

Hello André Wuthenow,

This calculated field might help:

It will calculate a unique rank based on the sales of the corporation for a specific category.
You can then drag this calculated field in the view and ensure that it is being calculated using Compute Using > Table down.

Final result is something like below:

Hope it helps. Thank you!
Like Show 0 Likes(0)

Actions
7. Re: Show rank of my company within each category

andwu Jul 4, 2017 11:53 PM (in response to T G)

Hi, again close. My column Sales should Show the sales on the market for all companies, see screeenshot attached.
Like Show 0 Likes(0)

Actions
8. Re: Show rank of my company within each category

andwu Jul 5, 2017 10:19 AM (in response to mara.quindoza)

Dear Mara,

thanks, that was what I was looking for!

Really appreciate your help, Mara & TG.
Like Show 0 Likes(0)

Actions