calculating cummolative QTY (of countdistinct) orders for every year
Hi I have a data set that has Purchse orders numbers, i wish to countdistinct, cummaltaive QTY for every year by date. so i will be able to produce line chart for every year, wehn the X- axis is months( jabuary, February,March....,December) the lines shuould display cummaltive QTy by month to month for each year. i have a dim_date table to use. thanks!!!