I have three categories in a text box. The measure is sum of sales. How can I add columns that show change vs. prior year and then % of total change for each category?
Then I would like to seperate each category into each own box or segment (preferably not one sheet for each) and have text that says 355 increase/decrease (depending on if it's positive or negative) and then one line below x% of total change. I would like this for each category. INitial spreadsheet attached. Thanks!!