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.