Just a quick attempt at what I think you are doing shows that it should work.
I have a calc that is doing COUNTD on customer names. Initially the sheet is displayed by day. Shrink the granularity to month, and it works.
You must be doing something different.
Can you hack up an example (or make this one look like yours) to show what you are doing?
The attached is V8.2. If you upgrade it, just let me know what version.
superstore -- countd dates.twbx 968.0 KB
Thank you for the response. I modified the calculation you are counting to mirror the one I am using. Your worksheet still seems to work correctly, though, and mine does not.
My problem may lie with the dimesion I am using in place of customer name. Other than that, I can't think of any reason why my sheet doesn't work.
I am using version 9.3.
superstore -- countd dates.twbx 979.7 KB
Yes, the sample worksheet works with your modifications.
So it demonstrates that it works.
Something else is going on in your actual workbook. The only thing I can do at this point is look at your actual workbook if you can upload it.
If proprietary info is a concern, try to anonymize it. Check out this video: