Optimizing Measures to avoid Out of memory errors

Hi Stachu,

Thanks for your quick response.

UniquesCount : is the count of unique Char Values that occurred first time within a year and not found in subsequent years. They can occur more than once within the year. I need to know their Firstdate of appearance (Item Appearance Date).

UniqueCharsCount : is the same as above. The only thing is i am counting their more than once occurence within the year as 1.

I need to know when UNIQUE Char Values appeared First time i.e FirstDate 

• for a BrandOwner (Manufacturer)
• in a Country
• in a Category

I also need to know when DISTINCT Char Values appeared First time i.e FirstDate for :

• other Brand Owners (Manufacturers) and when (FirstDate)
• in other Countries  and when (FirstDate)
• in other Categories and when (FirstDate)

i.e. how their paths have traversed across different Countries, Categories, Manufacturers over the years.

Also, is there a way to reduce file size for sharing purposes?

P.S: How do i anonymize this large data stretching different countries, categories, brand owners and years? Is there some free tool to do this?