11 Replies Latest reply: Jan 25, 2014 12:26 PM by Manish Kachhia RSS

    Struggling with Set Analysis

      Hello,

      I am struggling with something and would need help.

      I have a table with shows PLAN and ACTUAL SALES for Financial Year 2014.(which starts from Sept 2013)

       

      Now when I click on year it sums sales (i.e. 8) and sums plan (i.e. 43) .... but I want to find a way so that it sums plan only for the month where we have a sales numbers i.e. it should only sum plan = 2+3+4+3 ....

       

      Not sure how to find out the month which have actual sales.

       

      Month '14Plan($) ' 14Actual Sales($) '14
      Sep22
      Oct33
      Nov42
      Dec31
      Jan2
      Feb3
      Mar4
      Apr5
      May6
      Jun4
      Jul3
      Aug4
      Total438

       

      thanks in advance

      H