I have created a waterfall chart by month and segment.
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.
% 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?
Retrieving data ...