Forum Discussion

GilesWalker's avatar
GilesWalker
Icon for Skilled Sharer rankSkilled Sharer
9 years ago

YTD up to month selected help

Hi Everyone,   I am having a major issue trying to figure this one out. I have a table with sales data (volume, $, and dates) I also have a seperate DateKey table. What I am trying to get is if a u...
Need Help
SammiP's avatar
SammiP
Regular Visitor
5 years ago

Hi Giles,

 

Did you ever figure this out?  The YTD solution mthat people gave here, does the YTD for each month and then grows because it is like a cumulative total.  What Giles and I wanted was the Actuals for each month and then if the user selects April.  The April column will Have April's Data (NOT CUMULATIVE OR YTD) and in the Total Column the YTD from Jan - April.

 

I need help.