8 Replies Latest reply: Nov 17, 2016 7:07 AM by Kaushik Solanki RSS

    SET ANALYSIS: SHOW TOTALS WITHOUT SHOWING A VALUE IN THE DIMENSION

    Beatriz Manjón

      cedriclupo@ all,

       

      I am facing some problems when calculating a TOTAL expression:

       

      The problems is focus on one Dimension "Answer", which has two values, Yes and No.

       

      I want my expressions, to be calculating regarding the Yes Answers, but when I have to calculate an Expression called Total Answers, this has to take into account the total Answers (Yes and No) so when I put a total in my expression, the No answer in the dimension appears, and I do not want this value of the dimension to appear.

      The actual expression for this total answers that I have already is the following one:

       

      sum( TOTAL<Question, store,date, $(= GetCurrentField(TotalStores))>

      aggr(count( Answer),store,date  $(= GetCurrentField(TotalStores)),Question, Answer))

       

      Could some one advice me about how to do this total taking into accoun the "NO" Answers but in the dimension this value not to appear?

       

      You can find an example of the output I would like to get without the No value of the dimension to appear.

      Thanks in advance