8 Replies Latest reply on May 26, 2016 2:31 AM by Mahfooj Khan

    How to count the number of different categories within one dimension

    Sebastian Hopfensperger

      I'm not sure if I worded that correctly in the title but:

       

      I have 1 dimension called Sales that contains two categories: A & B.

       

      I am able to count the number of sales in total for the whole dimension, using a calculated field: Count([Sales]).

       

      However, I want to be able to count the total number of sales for A, and separately for B, within this single dimension. Preferably, I would like to create two different calculated fields, that can be use separately in rows/columns.

       

      Is there a way of doing this?

       

      Thanks