MTD and YTD data types in the same report

[Former Member]

Hi All,

I would like to know if it is possible to create a report that allows displaying two different data types (Month to Date and Year to Date). Furthermore the report should give the opportunity to select multiple values for the MTD and single value for the YTD.

Tks in advance,

F

[Former Member]

Hi,

The way I accomplished this in my reports was by using a structure. In one column create the MTD value by using a variable for the place in the month and applying a range <= variable. I used a second column for the YTD, again with a range variable that selected values <= the variable. I'm not sure how you could do multiple MTD values, since it would be placed in the structure, but you could create the number of columns desired and use an offset on the variable to select different months.

Hope this helps,

Rusty

[Former Member]

is this answered?