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

    Highlight Table Data Appearing on 2 Lines

    Chris Turnbull



      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