I have a large batch of data, below is just a short sampling of it, that I am trying to report on. If the same store, on the same date, had the same style I only want it to be counted 1 time when I pull the data into my pivot table. I've tried concatenating those 3 elements; Store Name, Show Date, & Style, thinking I could do something with that but everything I find wants to count them in the formula, but those are the 3 critical criteria to tell me how many times the style was shown. I'm thinking I just need them to have some numeric indicator so when I pivot the date and report based on style I can accurately show that even though the same style was in the same store on the same date it was only 1 "showing".

I'll also throw out it is absolute that all the data elements I need to consider are not together but separated by various other data elements.

* Note, the dates are in DD-MM-YY format...how my company does it.

I really am stumped. Any help you can offer would be grand.

HIDE FROM PDF RPRT Store Name Region Rep Name Show Date Style #
BVB XZY Store BVB Ann 15-10-16 ABT2245
UWBB Anything goes store South TAYLOR 22-10-16 ABT2245
BVB XZY Store BVB Ann 15-10-16 ABT2245
UWBB You're the bomb South TAYLOR 22-10-16 ABT2245
UWDS Anything goes store Midwest Madison/Morgan 29-10-16 ABT2245
UWDS Anything goes store Midwest Madison/Morgan 29-10-16 ABT2245
BVB XZY Store BVB Ann 15-10-16 ABT2245
UWBB You're the bomb South TAYLOR 22-10-16 ABT2245
UWDS Anything goes store Midwest Madison/Morgan 29-10-16 ABT2245