2 Replies Latest reply on Jan 13, 2014 1:05 PM by Chris Turnbull

    Highlight Table Data Appearing on 2 Lines

    Chris Turnbull

      All,

       

      A brief Outline of what each field represents:-

       

      We have 6 Data Inputs per year and in the workbook each one has a result_type _name eg. Yr07 AH2, Yr07 AH3 ETC ETC.

       

      I have a parameter called AHS Select where I choose one of these result_type_names and compare the points average with every other result_type_name points average and color code the Cell depending on whether it is higher or lower.

       

      I am having a little trouble whereby the Selected result_type_name is on a line below the measure for every other calculated average that it is being compared with and I cannot understand why.

       

      Any help greatfullyappreciated

       

      Thanks

       

      Chris