Dear all
I want to calculate the sales value with deferent sales prices for different periods. The sales volume has been uploaded weekly for 53 periods and the sales price are period depended like from 001.2008 to 015.2008, from 016.2008 to 25.2008 and from 26.2008 to 53.9999.
Please help me to write the formula for above scenarios.
Thanks in advance
Vinay Thakre