Please see the attached workbook. I changed your table calculation from percent of total to 'percent difference' This means that it compares each month to the prior month fish sales and then I made this a highlight table so the colours are based on this percent difference but the value showing is the actual amount.
I then made another calculated field which figures out the total number of fish for each type of fish. TOTAL(SUM([Number of Records])) - put that on the filter shelf and used the 'at least tab to 7'
Fish sales. InterWorks.twbx 14.1 KB
Yes, this is what I wanted. Thank you!@Carl Slifer