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

    Grand Total Display in 2 dimension Waterfall chart


      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?