Another crosstab issue

[dday01]

Hi All,

I have another crosstab issue, here is the layout of my crosstab:

Male Female
Contract A B A B

A is a summarized field in the crosstab (distict count of clients) B is a summarized field (Count of encounters). I want to add a third summarized field yields encounters per client. I tried to do this by creating a formula field that divides count of encounters by distinct count of Clients but when I try to put this in as summarized field in the crosstab it prompts you to put another function in front of it. Does any know how I can get this average encouters per client and get it into the crosstab. All help is greatly appreciated.

Thanks,

D

 

[pelajhia]

I think you can build the formula using the non-summarized fields and put it into the summary area; it will sum and divide. I think.

 

[dday01]

Hi Pelajhia,

I tried that but it did not work, Any other suggestions would be greatly appreciated.

Thanks,

D