4 Replies Latest reply on Sep 2, 2016 9:55 AM by John Burton

    Table with Count of Year Over Year Increases and Decreases

    John Burton

      Hi,

       

      I have some longitudinal data and I'd like to get a count of the number of year-over-year increases and decreases so I can put it in a table.  The table would be combined with a bar chart showing the same information on a dashboard.  I've created the bar chart without any problem but I'm not sure how to create the table.  The attached simplified workbook illustrates what I'm attempting to do.

       

      In addition, I'd really like to include more information in the bar chart using labels above the bars.  It won't work now because I've used "Detail" on the marks card to disaggregate the data.

       

      Thanks for your help!