Calculated Row and Ranking

[JCik]

Hi-

I have a table that has zip codes for rows and segmentation counts as columns.  I am agreggating on our trade areas, which is a set of zip codes.  I want to be able to have a visualization that shows me the top 5/10 etc segments present in this trade area.  Any idea how this could be accomplished?

Thanks!

[MFelix]

Hi @JCik,

The easist way is to use the TOPN filter option on the visual level or report level, if you want you can also use the RANKX function. However both of this options need to have a column as referenced to make the TOPN can you give based on the sample data and expected result and to what column you are comparing?

Regards,

MFelix

[JCik]

Thanks!  But I don't think that will work for this

In the example below I would only want to have the top 3 columns pulled into a visual or at least have a row below the totals with the ranking of that column so Money & Brains would be #1, Yound Digerati #2 etc

[v-jiascu-msft]

Hi @JCik,

What's "Money & Brains" in your first post? I'm afraid we can't add columns dynamically. I would suggest you unpivot these columns or create a new table.

Best Regards,

Dale

[JCik]

Money and Brains is a segment name (PRIZM segmentation).  Essentially my table consists of every zipcode in America as rows and then the 68 different segments as columns with # of HHs that fall into each segment as values.  We have defined trade areas (custom set of zip codes) that i wanted to show the dominant 5 segments in those areas but suspected that it might not be able to be done.

Thanks!