all, I need help
I have 3 columns of data
store id, store name and item no
if I create a Pivot by store name and count of item no
I get 250 store names and counts
this works
the problem is I am trying to perform a distinct count of SKUs across 5 stores
I can do this in a pivot using...