hello
i have a huge table and i used a pivot on it
to simplify it lets say i have 3 products sold during a month.
how can i find in how many days i've sold product A?
Count is not working because i need unique values (like in the table if in one day i've sold 10 products i have 10 line but i want it counted just once)
thanks
i have a huge table and i used a pivot on it
to simplify it lets say i have 3 products sold during a month.
how can i find in how many days i've sold product A?
Count is not working because i need unique values (like in the table if in one day i've sold 10 products i have 10 line but i want it counted just once)
thanks