Getting Counts for Previous Months in a Crosstab (DMR)

[gosoccer]

Hi folks, :) :)

If someone could just provide some steps in which I can have a Crosstab that the Top Edge shows different CARs but the Left Edge shows the months for each car sold, I would greatly greatly appreciate it.
I have attached a spreadsheet showing what I'm trying to do. The main issue is to rollup or add the previous months Car Sold
to the next months car sold. So, if the Crosstab Edge is showing the month of Jan, I need to include the last year's counts
as a part of the overall count of BMW sold for January.

Please see my attached.

So, in this case, I have to get the Nov-16 to include the Oct-16 Cars Sold.

I changed to DMR from Relational since I'm hearing, it might be easier.

Thanks so much for your time. :( :(

[MFGF]

Hi folks, :) :)

If someone could just provide some steps in which I can have a Crosstab that the Top Edge shows different CARs but the Left Edge shows the months for each car sold, I would greatly greatly appreciate it.
I have attached a spreadsheet showing what I'm trying to do. The main issue is to rollup or add the previous months Car Sold
to the next months car sold. So, if the Crosstab Edge is showing the month of Jan, I need to include the last year's counts
as a part of the overall count of BMW sold for January.

Please see my attached.

So, in this case, I have to get the Nov-16 to include the Oct-16 Cars Sold.

I changed to DMR from Relational since I'm hearing, it might be easier.

Thanks so much for your time. :( :(

Hi,

So is this really a running total you are looking for? If so, Paul has a great technique for this when using a dimensional package:

http://www.cognoise.com/community/index.php/topic,6378.msg21477.html#msg21477

Cheers!

MF.

[gosoccer]

Thanks. I wish I was better in what I do. 10 hours later. Not there yet. Weekend shot.

I'm trying to achieve this in Relational now since DMR took forever to bring anything back.

I build UNION with couple of Queries within the Report Studio. The counts matches to what I have in
DB2 DB. SUCCESS!!

Anyways, for some reason, the first of month is bringing the records for the month from the first of month. I need to the records to be counted from the previous MONTHS before Dec 2016 in this case no matter what the months are prior to the
latest date. 

_first_of_month([Open_Query].[S_DATE])

The following is giving me an error,
[Open_Query].[S_DATE]<=_first_of_month([Open_Query].[S_DATE])
If I can figure this out in Relational, I'll be a FREE BIRD flying in the sky!!!!!! :) :)
Thanks a lot!!