1 Reply Latest reply on Jun 20, 2012 4:33 AM by Russell Christopher

    How do I create a chart from a calculated measure?

    Christopher Henderson

      Hi

       

      I have created the following calculation to allocated and "account category" to each of our accounts.

       

      IF SUM([Gelatin Variance]) <=0

      AND SUM([Starch Variance]) <=0

      THEN "Crystalloid Grower"

      ELSEIF SUM([Gelatin Variance]) >=0

      AND SUM([Starch Variance]) <=0

      THEN "Gelatin Grower"

      ELSEIF SUM([Gelatin Variance]) <=0

      AND SUM([Starch Variance]) >=0

      THEN "Starch Grower"

      ELSEIF SUM([Gelatin Variance]) >=0

      AND SUM([Starch Variance]) >=0

      THEN "Fluid Grower"

      END

       

      This works fine when I bring the account name into view. All of the accounts have the correct account category allocated to them. My problem lies with creating a simple chart to show the number or count of accounts that are a Gelatin Grower, Starch Grower etc etc. The reason I am struggling is that in order to create the chart I assume I somehow need to factor in the account name so that the account categories are summed. I hope this helps. My desired output is a chart that looks like the attached pic.

       

      Many thanks for any help with this.

       

      Chris