Hi I have an power pivot table. And I would like to know the last vendor we bought a product from.
My tables are all connected to the PRODUCTS table. I have SALES and RECEIVINGS. The link is sku# to all tables.
I would like to find out the last VENDOR it was purchased from. But the RELATED function doesn,t work. Is there a formula for this?
My tables are all connected to the PRODUCTS table. I have SALES and RECEIVINGS. The link is sku# to all tables.
I would like to find out the last VENDOR it was purchased from. But the RELATED function doesn,t work. Is there a formula for this?
