1 Reply Latest reply on Mar 30, 2012 2:43 AM by Jonathan Drummey

    How do I create a peer group ratio ?

      I need to learn how to create a line graph view containing ratios over time for a single company and also for its state peer group.

       

      I created a calculated field for a net worth to totals assets ratio. I have dimensions for State and for Peer Group Number. Say that my company's State = FL and Peer Group Number = 4.

       

      If there are ten other companies with State = FL and Peer Group Number =4, how do I create a peer group (calculated field ?) showing their combined average net worth to total assets ratio ?