Compare two year column

[Former Member]

Hi to all,

I'm new at Crystal and I have a question.

I have a source table that have the following layout:

NAME DATE SALES_VALUE

aaaaa Jan09 1000

bbbbb Feb09 1111

ccccc Mar09 1010

aaaaa Jan10 1200

....

I want to create a report that compares the same month on diferent years like the following:

NAME JAN09 JAN10

Of course, the month is not fixed, but it will be a parameter defined by the user...

Can anyone help me?

Thanks,

Luis

[Former Member · Accepted solution]

Will there always be just two years being compared ?

[Former Member · Accepted solution]

yes. There is another column, but it's a variance...

[Former Member · Accepted solution]

You could create a formula, and group off of it.

day()&" "& month()

If you go to details section and check Format with Multiple Columns

you will see a layout tab pop up.

click on it, select the proper width

and across then down

then you will get your two columns.

Something like this

NAME DATE SALES_VALUE NAME DATE SALES_VALUE

aaaaa 01/01/2010 1,000.00 aaaaa 01/01/2011 1,507.50

aaaaa 02/01/2010 1,952.50 aaaaa 02/01/2011 2,397.50

bbbbb 01/10/2010 1,240.50 ccccc 01/10/2011 1,908.00

bbbbb 02/10/2010 2,353.00 ccccc 02/10/2011 2,798.00

[Former Member · Accepted solution]

Sorry... I didn't understood.

You are saying to create a formula with the "value" month(DATE)& " " &year(DATE)

After that create a group with that. I done this.

Now on the detail section I selected the format with multiple columns, the layout, the width and the across down...

But it doesn't appear the two columns...

The formula that I created is as following:

year(cdate({TT_T_FI30.SPTAG})) & "-" & month(cdate({TT_T_FI30.SPTAG}))

May be there is something that I didn't do it...

Luis

[Former Member · Accepted solution]

Hi Luis,

Drop the formula into the group, just so you can make sure it is grouping correctly.

And check to make sure the layout tab "Details Section" has format groups with multiple columns checked

You should see two columns of data, in the details and the groups.