2 Replies Latest reply on Dec 10, 2019 8:46 AM by srinivas s

    Grand total is not visible for few Variables

    srinivas s

      Hi All,

      • it's simple logic ,but it's not coming.
      • I was taking few metric's those all are Aggregations . while doing dashboard I just took Grand total at bottom .
      • every metric has got the grand total except one metric.i don't know why happened .

       

      Jim Dehner Could please help me out here why this happening.

       

      anybody please help me here .this bit urgent to me . I have attached the snap  and Twbx file.

       

      Note:- Grand total is ( if sum up all values of particular metric then it's matching with it's grand total.

       

       

      Regards,

      S.Srinivas

        • 1. Re: Grand total is not visible for few Variables
          Jim Dehner

          convert the m.cost to an lod as shown below

           

          { FIXED [Program]:(

          CASE min( [Program] ) WHEN 'POST' THEN [Post]

           

           

                         WHEN 'PRE3001' THEN [PRE3001 and PRE3002]

           

           

                         WHEN 'PRE3002' THEN [PRE3001 and PRE3002]

           

           

                         WHEN 'NCOA_MONTHLY' THEN [Monthly]

           

           

                         WHEN 'NCOA_WEEKLY' THEN [Weekly]

           

           

                         END  )}

           

           

           

           

          and it will return this

           

           

          Jim

          If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

          • 2. Re: Grand total is not visible for few Variables
            srinivas s

            Thanks Jim

             

             

             

            Regards,

            S.Srinivas