2 Replies Latest reply on Mar 16, 2017 2:41 PM by Patrick A Van Der Hyde

Automatic calculation: difference to Top 3 of a peer group

robert.linz Mar 7, 2017 5:52 AM

Hi all,

I have a list of values of a peer Group for each quarter (attached screenshot).

I want to calculate the difference between "1" of "Konzern" and the Top3 of the peer group (in this case "8", "6" and "4").

I need an automatic calculation of the difference, because the Top3 of the peer group could change every quarter.

The results (difference "1" to TOP3, ... to TOP2, ... to TOP1) should be shown separately.

I hope you can understand my problem.

Thanks in advance, Robert

1. Re: Automatic calculation: difference to Top 3 of a peer group

Yuriy Fal Mar 16, 2017 2:39 PM (in response to robert.linz)
Hi Robert,

I've used Sample Superstore.
The [State] mimics your [Konzern].
The ranking is by Sum of Profit.

Please find the attached (version 10.0) wb.
Hope it could help a bit.

Yours,
Yuri

Diff_from_Top_N_peer_YF.twbx 1.2 MB
Like Show 0 Likes(0)

Actions
2. Re: Automatic calculation: difference to Top 3 of a peer group

Patrick A Van Der Hyde Mar 16, 2017 2:41 PM (in response to robert.linz)

Hello Robert, there are several resources in the forums and online for help with Top N. Have you looked over these already? If you are still in search of assistance, please upload a packaged workbook for the community to review and assist further.

Thanks

Packaged workbooks: when, why, how

Patrick
Like Show 0 Likes(0)

Actions

Tableau Community