6 Replies Latest reply on Feb 9, 2012 9:41 AM by Jonathan Drummey

    Crosstab and standard deviation from the mean

    Matt Francis

      I've been asked to try to create this kind of view from a csv file that contains 1 dimension and 1 measure. The user wants to know how many times the measure for a dimension is below 1stdev, within 1stdev and above 1stdev of the mean. The table would look something like

       

      Below     Within     Above

      23          244          231

       

      The fields in question are Filenae and Churn.

       

      I know its probably very straightforward but i am having a major brain fade moment so any help would be great.