I have a group of data in a sql server database that I am trying to use power pivot to create a table of values for. The fields in calculation are:Type of toy, Average sale price for each type of toy, the quantity purchased for that type, and the purchase price.
I would like to get power pivot to perform the following:
the sum of the below formula for each type of toy:
((Average sale price-purchase price)*Quantity purchased)
Any and all suggestions are helpful.
I would like to get power pivot to perform the following:
the sum of the below formula for each type of toy:
((Average sale price-purchase price)*Quantity purchased)
Any and all suggestions are helpful.