1 Reply Latest reply on May 19, 2017 9:31 AM by Patrick A Van Der Hyde

    How to seperate text box into different boxes

    Alex Martino

      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!!