5 Replies Latest reply: Apr 20, 2009 8:04 PM by Oleg Troyansky RSS

    Set Analysis question

    Oleg Troyansky

      Folks,

      I'm having a brain freeze, please help!

      I have daily Sales numbers and monthly Plan numbers. The monthly Plan is recorded with the date of the MonthStart() - e.g. 1/1/2009, etc...

      I want to show a line chart with daily sales and average daily Plan (e.g. the Plan for the same Month divided by 20). Can I do it with the set analysis? No matter what I do, I'm getting some numbers only on the 1st of each month, but not on other dates...

      thanks in advance!

      Oleg