2 Replies Latest reply: Sep 24, 2012 4:22 AM by Chirag Chhatralia RSS

    Calculating sales to the date a user select

    Chirag Chhatralia



      I'm struggling with what I believe should really be a straight forward issue and need some help.


      I want to calculate what the sales are upto and including a date I select from the date dimensions.  I also want the other dimensions open i.e. so I can select a specific product or region, etc and see it's sales to date.  At the moment I have sale to date using set analysis and the {1} however this is fixing the date and ignoring all other selections made.  I want to fix my date and let the user select the other dimensions.


      In the attached example I have named varibles for the date that my data begins i.e. vStart and the last day of the selected month i.e. vEnd.


      Please could some one help?


      Many thanks in advance.