I currently have two tables. My first table is my products table and what I am trying to visualize in the product table is the number of products quoted or not quoted the past year. So, I have '1' for product not quoted and '0' for products that are quoted. I was able to calculate these measures by creating a calculated field from a percentage measure where if products not quoted is 100% then that means it has not been quoted and if it is 0% then it has been quoted. However, when I try to roll up at the vendor level I cannot get my products not quoted equal to products not quoted at the vendor level. I have some duplication issues so that is why I had to resort to the measurements I just mentioned.
You'll need to upload a sample workbook. (Even just one made on bogus excel data sources, so that I can see how you have those tables interacting with each other, and what your aggregate calc looks like.)
I can help you, but I'll need something concrete to work with.
Become a Viz Whiz on the Forums! Support the Community and master Tableau.