This content has been marked as final. Show 2 replies
I have a dataset of sales from different Stores and those related to the customers ID, product Id and so on... and I need to be able to SUM the number shops that have made any sales per day.
I have 100 Stores (Maximum)
If I use the function COUNT (Distinct "Store Name) the result will depend on the dimension, so:
For this Example supose that The month only have "3 Days"
Day Month Count (Disntinct "Store Names")
1 1 100
2 1 95
3 1 80
If I take out Dimension Day from the above table, then Count (Distinct "Store Names") will take account the month as a whole and the result will be 100.
Month Count (Disntinct "Store Names")
- I need to get the sume of Number Stores Open Every Day: 100 +95 +80 Regardless of the dimension I use, I need this function to be limitd to count per day dimension.