9 Replies Latest reply: May 17, 2010 5:42 PM by Dinesh Thoniparambil RSS

    Conditional Sum

    Dinesh Thoniparambil

      I have 2 columns. Year (Dimension) & Flag (Y/N). I want to show a line graph with year as dimension & 2 lines (count of all Y & count of all N). How can I create a new measure which is essentially a conditional SUM. Something along with this line: SUM(if flag = 'Y' then 1 else 0) or count(*) where flag = 'Y'.