2 Replies Latest reply on Dec 30, 2013 1:38 PM by jaimie.stark

    Conditionally hide columns and use in table calculation

    jaimie.stark

      I have a chart similar to my attached sample with Effective Date and Headcount. We refresh the chart monthly and I need to always show the 13 most recent Effective dates, including the headcount and the YTD headcount % change from January of the corresponding year. For example, the December 2012 % change value should reflect % change from January 2012 headcount; for all 2013 months % change should reflect % change from January 2013 headcount.

       

      I can visually create the desired result by manually hiding January-November 2012, but this would create maintenance with each refresh. If I filter to display the Top 13 Effective Dates, then the excluded values are excluded from the 2012 % change calculation so this doesn't quite work. Any advice would be much appreciated! Thanks!