I added a matrix table to a report and a subtotal row.
I have buyers and a measure buyers count. Buyers is the total sum where
as buyers count is like a distinct count if on buyer comes twice.
Now I'd like to display this for several stores.
I created a matrix with the storename as a column group and a subtotal
column. I built my 2 measures in the cube but my subtotal delivers
wrong results because if one buyer buys in 2 different stores it should
calculate also the distinct count but it sums the buyers up.
any ideas?