Crosstab- need a distinct count for each row
Posted on 2014-11-24
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?