9 Replies Latest reply on Aug 24, 2018 4:26 PM by Okechukwu Ossai

    Extracting largest and second largest dimensions as field

    Michael Ejigu

      Unfortunately I can't include the packaged workbook as it contains sensitive data, but hopefully these screenshots will suffice. Basically I have a dataset that looks like the first screenshot (current), and I need to extract (for any given state/dimension) the source that is generating the most views, and the source that is generating the second most views. I'm not looking to pull in the number of views that the source is generating, but rather the name of the source itself. Ideally, the output will look exactly like what I have in the second screenshot (desired). Any and all help would be much appreciated.