Hi Alex, is there a way to count unique dimensional items and have them show up as a count column?
I've got a flat data file like so:
CustID-1 M Day-1 Amount
CustID-1 M Day-3 Amount
CustID-2 F Day-1 Amount
CustID-2 F Day-2 Amount
CustID-2 F Day-3 Amount
If I add a count column that counts CustID and then group by gender and then CustiID I get the following:
M - CustID1 Count = 2
F - CustID2 Count = 3
What I end up with is a vist count (i.e. on how many days each customer visited and spent money) but not an actual customer count.
Is there a way to get around this?
Cheers,
Matt.