2 Replies Latest reply on Mar 5, 2018 9:43 AM by Jim Dehner

    Table calulation

    sarvesh chandra

      Have a stacked bar graph to display.

      wanted to show the split using the color shelf.

      But I want to show only 2 values as a percentage of total in the stacked bar and filter out the rest.

      When using table calculation it calculates the percentage of total  taking into account only for the filtered out values i.e at the view level , want to retain the percentage of total even after filtering.

       

      attached is the book for reference

        • 1. Re: Table calulation
          Jim Dehner

          Good morning

           

          One way to do that is to use an LOD expression to calculate the denominator on your percentage calculation

           

           

          The fixed LOD will give you the total count of Type copy and is independent of the filtering

           

          it returns 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.

          1 of 1 people found this helpful
          • 2. Re: Table calulation
            Jim Dehner

            Good morning

            did the solution I provided over the weekend give you what you needed

            If so please mark the solution correct to close the thread

            Jim

            1 of 1 people found this helpful