asked on Crosstab- need a distinct count for each row
I have a crosstab listing each product number as row and each "selected" store as column. Summary is the # sold for each item/store. I need to do a distinct count of the stores selling each item and put it in the Total column only. I can do this for each column, and it works quite well. I cannot figure out how to place this in the Total column only. I tried an embedded summary, and this gives me a column with each line the entire count of stores.
Is there a way to do this?
Is there a way to do this?
Crystal Reports
Last Comment
James0628
If you're getting the grand totals that you want, and the problem is simply that you don't want to see the subtotals in the columns, you could try making the field as small as possible and suppressing it.
James
James
ASKER
I have tried suppressing the column, as James0628 suggested, which works for printing or viewing, but the request is to be able to export this to Excel, and then there will be an empty column in the spreadsheet, which the users do not want.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
mlmcc