Calculate Square Footage Sales by Product

[Anonymous]

I am trying to create a measure that can be used to return the total sq footage sales for each product. All products vary by what number to multiply the order quantity by to get the square footage sold. The calculation for sq foot sales also depends on if the product is sold by the box, piece, etc. 


I need help creating the measure that would allow me to dynamically calculate the sq footage sold for each product. I have a dimension table with the product info (what ratio to multiply by, if its sold by box, pallet, etc) and a fact sales table. 

This one hurts my brain, so any help/guidance is appreciated!

[Whitewater100]

Hi:

This sounds like a fun challenge. Are you in a retail environment? Or can you provide more background on where te sales are coming from for these products? For example if you had a 4' section at Target - that would be fairly easy to figure out, allocating finger space ,etc.

Generally, you sq FT calculation is more about the width & height of the product (not the depth). You would multiple those dimensions together and divide by 144, for total square footage. (/1728 for cubic).

If you are working with a retail and reporting on their terms they most likely will want you to add some aisle space/adjacencies space to report on the footage in store based on planogram.

Hope this helps a bit. Thanks..

The measure won't be too hard once you have the ground rules in place.

To make this calculation fair, you would have to have the smae sales opportunity for each product involved.