-
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
-
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
-
3. Re: Show rank of my company within each category
T G Jul 4, 2017 5:19 AM (in response to andwu) -
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
-
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
-
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!
-
-
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.