Sigma Community

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

system automatically bumped May 25, 2021, 5:54am #12

system automatically bumped June 16, 2021, 9:41pm #13

system automatically bumped July 9, 2021, 5:56pm #14

system automatically bumped August 1, 2021, 6:07am #15

system automatically bumped August 24, 2021, 7:17am #16

system automatically bumped September 16, 2021, 7:11pm #17

system automatically bumped October 10, 2021, 10:47am #18

system automatically bumped November 3, 2021, 1:04pm #19

system automatically bumped November 27, 2021, 4:30pm #20