Crosstab

It should be.

Simply add bith fields as the summary fiekds.

mlmcc

Hi
Sorry I have not understood this. what are bith fields...?? can you pls provide more details.

When you create the cross tab you can add row and columns and you also can add the fields for the summary.  If you add both A and B you should get what you want.

mlmcc

Sorry that should have been BOTH

mlmcc

When i add Both fields for summary..in crosstab it shows one below the other...I need it side by side sepearted by "/". Somthing like this (250 / 300) in the same line.

Hi,

Formula is working great thanks. Can i also have the Background color for the CStr({B},0,"") in this formula.

As far as I know the background color will apply to the whole cell.  You can't change it for part of the cell.

mlmcc

Nice idea.  I just tried it in a cross-tab here and it worked to a degree.  I did not get a "/" in the cells where both numbers were 0 (meaning that there were no records for that cell).  That field just doesn't show up in those cells at all.  Maybe there's a way around that, but I suspect not.  But if that's not a problem for the OP (either because they don't have any cells like that, or because they don't mind not getting a "/" in the "0" cells), then that may be the best solution yet.

 James

You could suppress the zeros also.  You have to format the cell go the number tab, click custom and check mark suppress if zero.  That way the entire field will be blank.  

True.  Of course if there are some cells where one number is 0 and one is not, that might not work so well.  You'd have one number and the "/", but not the other number (0).

 James

I would give some points to corobv as well, for post 24440334.  His idea of adding a "slash" formula to the cross-tab was simple, and worked well in my test, apart from not showing up when both of the numeric summaries were 0, which may not have been an issue for the OP.

 James