Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2012
    Posts
    7

    Unanswered: Deriving DLY and MTD Revenues from YTD

    Hello,

    I am creating a data warehouse table. The source data only has YTD rev totals.

    How can I create a query that calculates the DLY & MTD rev values?

    Any assistance would be greatly appreciated.

    Thanks!
    Zack H.

  2. #2
    Join Date
    Jun 2007
    Location
    germany
    Posts
    155
    do you want them to be accurate (actual real figures)
    or just calculated?
    Dick Brenholtz, Ami in Deutschland

  3. #3
    Join Date
    Feb 2008
    Location
    Japan
    Posts
    3,483
    How was YTD stored in the source data?
    Are there rows for each days? Or, a row has columns for each days?
    How do you want to store YTD in the warehouse table?

    Please publish sample data.
    Last edited by tonkuma; 08-10-12 at 20:13.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •