not exactly what I was looking for as it uses a table calc. I want to be able to create a crosstabl that looks like:
company number company name date total sales
123 abcnewname 1/31/15 xxx
123 abcnewname 2/28/15 xxx
I always want to see company name for company 123 listed as "abcnewname" for any and all months of sales
Does this work for you?