6 Replies Latest reply on Oct 1, 2018 1:16 PM by Don Wise

    How do I count rows per measure value?

    Vincent Baumel

      My data set describes products that both a width and a height. I want to see what our most popular dimensions are, and what combinations of dimension are the most common. My first thought was to disaggregate the measure and make it discrete, which gives me something to work from:

       

       

      I can visually see how many items exist per measure by looking at the Abc values. How would I count these though? With my data disaggregated, I'm not sure how to add up the # of rows.

       

      I'll attach a workbook just in case. I'll use World Indicators, since it usually lives in the shadow cast by Superstore.

       

       

       

      Thanks,

       

      Vince