2 Replies Latest reply: Dec 2, 2013 9:43 AM by Gysbert Wassenaar RSS

    'TOTAL' in GRID CHARTS

    susvithrocks susvithrocks

      Hi all,

       

      How to display the total on both sides(horizontal and Vertical) in a grid chart?

       

      PS: just like attached excel snapshot

       

       

      any help would be appreciated.

       

      Regards,

      Susvith

        • Re: 'TOTAL' in GRID CHARTS
          Israr Khan

          Hi,

          Grid Chart Shows data in Symbol/ graphical way, not in text format..

          i think you cant do it,

          But, you can create label object and place them below each total, and set layout >> layer property to top,  for all labels.

          and in label you can use the expression to calculate totals.

           

          it might work...

          • Re: 'TOTAL' in GRID CHARTS
            Gysbert Wassenaar

            It should be possible if you create two new dimensions in the script based on the two you use in the chart. Suppose you have a dimension Product:

             

            Product
            Apple
            Banana
            Chocolate

             

            The new table would look like this:

             

            ReportProductProduct
            AppleApple
            BananaBanana
            ChocolateChocolate
            TotalApple
            TotalBanana
            TotalChocolate

             

            Now you can use ReportProduct in the grid chart instead of Product to show the totals too.