0 Replies Latest reply on Sep 28, 2018 1:23 PM by susheela.hegde

    Grand Total Display in 2 dimension Waterfall chart

    susheela.hegde

      Hi All,

       

      I have created a waterfall chart by month and segment.

       

      sheet 1:

      This is a waterfall model which is the running total for every month . I also have % of sales from Previous month across each segment in tool tip.

       

      Sheet 2:

      % of sales for every month along with row grand total.

       

      I wanted to show sheet 2 in terms of waterfall model , how ever I am not able to show row level grand total in sheet 1. Is there a way to show grand total % of sales like sheet 2 in sheet 1?

       

      I am basically wanting to show the performance of segment over time.  Is there any other better way to show this?