product list question

 

On the right side I have a list of products and revenue and on the left there is the total

 

is there a way that the left side is populated with a singular value for product name based on adding to the right hand side, for example if i copied multiple values for new products how can i get them to appear consolidated automatically on the left hand side (product name i mean, if i add 3 product D’s then one product D appears on left side

 

Product revenue   unique product name revenue
a 10   a 40
b 20   b 100
c 30   c 130
a 10      
b 20      
c 30      
a 10      
b 20      
c 30      
a 10      
b 20      
c 30      

Thanks

By: Gary Myler

Leave a Reply

Your email address will not be published. Required fields are marked *