Hello Chits -
Sheet 2 is showing the percent difference to the previous month. For instance - January of 2017 for Consumer is 23212 and February is 5589 so the value of -.7592 is a percent difference to the previous value of that row. That's not the same as percent of sales for every month as you indicate so I am not sure what is wanted here. Should that value be a percent of total sales for the month for each Segment?
When creating example workbooks, please try to show as many details as possible so for sheet two - just putting sum(sales) on the view helps a bit but also showing LOOKUP(SUM([Sales]),-1) helps so that someone looking to assist can see you all of the values right there in the cross tab.
To get back to the original intent of sheet 2 - please let us know what value is desired for the performance over time? Is it performance to the previous month? performance to the previous year? Percent of total for the year? some sort of comparison to the other segments?