0 Replies Latest reply on Mar 21, 2012 1:51 PM by geoff.clemm

    Counting distinct parent companies (Window_CountD?)

      Hello,

       

      I have created a pricing matrix for companies based on the number of cylinders the parent company holds and that company's total gas spend (screen shot attached).

       

      I did this using the fields "Total Cylinder Gas" as colums and "Number of Cylinders Held" as rows, as defined below:

       

      Example- Number of cylinders held:

      IF WINDOW_SUM(SUM([Gas Revenue])) > [Cylinder Partition 4] THEN "E (HIGH CYLINDER COUNT)"

      ELSEIF WINDOW_SUM(SUM([Gas Revenue])) > [Cylinder Partition 3] THEN "D"

      ELSEIF WINDOW_SUM(SUM([Gas Revenue])) > [Cylinder Partition 2] THEN "C"

      ELSEIF WINDOW_SUM(SUM([Gas Revenue])) > [Cylinder Partition 1] THEN "B"

      ELSE "A (LOW CYLINDER COUNT)"

      END

       

      I then drop the field for parent company in the level of detail.

       

      I would like to count the number of distinct parent companies in each part of the matrix to represent the size of the bubble. Ideally, I would create a table caculation somethign like Window_CountD (CountD (Parent_company)). However, there doesn't appear to be an option for this...

       

      Any help would be greatly appreciated! Thank you.