Selecting Nth Value per Grouping

Sigma Formulas and Functions

ztrean October 30, 2020, 7:38pm #1

I have a grouping that has the annual revenue per company, is there any way I can add a column that selects the 10th highest company per year?

Ryan October 30, 2020, 7:38pm #2

Hey Zachary!

You can select the 10th value by using the Nth() function!

system automatically bumped November 18, 2020, 9:31pm #3

system automatically bumped December 8, 2020, 5:01am #4

system automatically bumped December 27, 2020, 4:34pm #5

system automatically bumped January 16, 2021, 8:48pm #6

system automatically bumped February 6, 2021, 5:37am #7

system automatically bumped February 27, 2021, 3:02pm #8

system automatically bumped March 21, 2021, 12:51am #9

system automatically bumped April 11, 2021, 2:37pm #10

system automatically bumped May 3, 2021, 9:55am #11