1 Reply Latest reply on Sep 21, 2017 11:14 AM by Derek Thomas

    How to best arrange this data

    Derek Thomas

      Hello,

       

      I am working on this tool, and attached is the data I've been using.

       

      The "tall" tab is how I initially uploaded it, but as you can see in the screen shot below, there are only two measures, FY 2017 and FY 2018.

       

      How can I arrange the data so that measures are labeled the way that they are in column H of the attached spreadsheet (the colors correspond with the labels in column H).

       

      Another consideration is that I want to be able to easily update the workbook in future years (when new budgets are released).

       

      Thanks kindly for any assistance with this.

        • 1. Re: How to best arrange this data
          Derek Thomas

          Actually, the other thing is that this is only one agency. I would like to add 3 additional agencies so that users could select from different agencies. For example, instead of "DFTA Overview", it would say "agency overview" and so forth.

           

          Then again, doing so would mean I probably wouldn't be able to customize in the "intro" and "appendix" as they are now.

           

          Any thoughts or suggestions would be greatly appreciated.