Showing posts with label crosstab. Show all posts
Showing posts with label crosstab. Show all posts

Sunday, February 19, 2012

Column Heading in Crosstab

I have a crosstab that contains dates grouped by week as the column. Since it is grouped by week it gives Sunday as the start date of the week. Does anyone know how I can change it so that it will show Monday as the beginning of the week?Create a formula having this code
weekdayname(weekday({datefield})+1)
Now Group the report by this formula|||I tried this formula in my crosstab and it seperated the columns into Monday, Tuesday, Wednesday etc. I need it to show the dates. For example, what it shows across the top now is:

6/5/05 6/12/05 6/19/05 6/26/05

what I need it to show is the week starting on Monday:

6/6/05 6/13/05 6/20/05 6/27/05

Any help would be appreciated.

Tuesday, February 14, 2012

Column calculations in Crystal crosstabs

Can anyone help with how to calculate a percentage variance on 2 columns of a cross tab. The number of columns in crosstab can vary from 2 to many more. The percentage variance needs to be calculated as:

if first column then "colunm data" else
((this column - previous column)/Previous column )*100

How do I reference the columns in a crosstab?Just a *Bump* of sorts, I suppose.

I'm looking for a similar solution, though I'm not looking for a percentage variance. I'm referencing dollar amounts by category, broken out over two calendar years.... so far so good in the cross-tab. Totalling the fields is of no value, so I've suppressed the totals columns/rows. What I do need to be able to do is to subtract the 2007 data from the 2006 data to come up with the raw difference. For example, in the attached screen shot, I need to subtract the 2006 data from the 2007 data moving across.

How can I create a formula to accomplish this?

Any assistance from the experts is greatly appreciated. One of these days I'll get to take my swim fins off....