cross tab summarized fields 1

[nb4884]

Hi ,

Ver CR XI

I have 2 fields in summarized fields of a cross tab and one field of column. Data is such like there are 5 values for column means 5 columns and there are 2 summary fields , which means in total i have 10 columns.

Currently the report displays column1summary1 column1summary2 column2summary1 column2summary2 and so on (I checked horizontal and not vertical option)

Is there a way to display the columns in a way that the report displays first five columns for summary 1 and then the next 5 columns for summary 2?

Such as column1summary1 column2summary1 column3summary1..... column1summary2 column2summary2 column3summary2...


Thanks

 

[lbass]

Yes, there might be, but it would be easier tell if we knew what kinds of fields you were working with. What values does the column field return? What are the fields you are summarizing? What datatype are column and summary fields? What kinds of summaries?

-LB

 

[nb4884]

Column has 5 departments and returns department accounts , admin, HR, IT, Customer Service.

I have department field as a column.

Fields to summarize are number of employees and it is a sum. There are 2 summary fields number 1 and number 2 and it is derived from a formula [if year 1 then number 1(sum of employees) and if year 2 then number 2(sum of employees)]

Rows display the details of a project.

Right now it displays as Accountsnumber1 accountsnumber2 adminnumber1 adminnumber2 but i want to display as accountnumber1 adminnumber1 hrnumber1 .....

 

[lbass]

Please the actual content of the formulas you are summarizing. It appears that instead of creating conditional formulas for your summaries, you should instead be adding the year as your first column, then department as your second column. Then just use sum of employees as your summary field (one summary field).

-LB

 

[nb4884]

Thanks LB,

My summary is based on a formula which calculates number of emps in a year and second summary formula calculates number of emps in next year.

@NOE1 = if ({query1.hire Date}) in date(2011,04,01) to date(2012,03,30) then ({query1.employee number}) else 0


@NOE2 = if ({query1.hire Date}) in date(2012,04,01) to date(2013,03,30) then ({query1.employee number}) else 0

Dont know how should I add year as a column since the emps are calculated in a formula based on a year

Hope this description is helpful. Also I was thinking to may be just build a manual cross tab by inserting formula for each department likewise 10 formulae , do u think crosstab is still a good idea for any particular reason?

Cross tab will require further formatting in building the row headers , I have about 15 fields for rows.


Thanks

 

[lbass]

Your first column field would be:

if ({query1.hire Date}) in date(2011,04,01) to date(2012,03,30) then "Year 1" else
if ({query1.hire Date}) in date(2012,04,01) to date(2013,03,30) then
"Year 2"

Your summary field would be {query1.employee number}.

-LB

 

[nb4884]

Awesome LB That works great. Thanks for taking out time to provide the solution (everytime .