5 Replies Latest reply on May 30, 2018 9:51 AM by Shinichiro Murakami

    Calculate % of total based on two of three dimension's values

    Chao Chen

      Hi, I'm trying to calculate a % of total calc based on only two measures within a dimension that has three measures.

       

      The dimension is called, let's say: Results

       

      Within the results, you have three measures: Pass, Fail, N/A

       

      And then you have the number of records for each of the Pass, Fail, and N/A items.

       

      I need to calculate % of total using only the Pass and Fail items.

       

      I can't exclude N/A from view because I need to show the # of records.