Count distinct dates in a year, month and country

Noel Odalager

Hi,

Can anyone help? I need to count unique dates in a certain year, month and country so i can monitor the unique date entries in that country on a monthly basis in that year.

TIA

iLoveData

@Noel Odalager

Hi Noel,

Do you need these counted as in a sum of the number of unique dates or do you need them listed out? Also, do you need this at the line item level or would you want the value within the entire sheet?