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.
Showing posts with label crosstab. Show all posts
Showing posts with label crosstab. Show all posts
Sunday, February 19, 2012
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....
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....
Subscribe to:
Posts (Atom)