
Hi
I have below fields Product Id , Description , Month , Year . Primary Key should be Product Id , Month , Year.
I want Matrix Form . Against every ProductID moneth & year wise WholeSale & Retail price will be entered.
WholeSale Price Retail Price
ProductId1 Description
ProductId2 Description
ProductId3 Description
ProductId4 Description
Thanks
*This post is locked for comments
I have the same question (0)You can use the Analysis View Tool in Microsoft Dynamics NAV to be able to do your Matrix form as a report view.
You can search for "Sales Analysis By Dimension" in Microsoft Dynamics NAV.