1 of 1 people found this helpful
You posted your question already 2 days ago.
Could you elaborate on what you exactly desire with an example or a visualization so the community gets a better understanding.
For sure when the community has a good understanding they will be able to help out.
Upfront thanks a TON!
Have a nice one.
Attached is a document showing a screen shot of the end result data that I am trying to achieve and some more data.
Hopefully this will clear things up a bit more.
Any help would be awesome!!
"From the data we have a series of volumes for each ISO Week. The current year start dictates what ISO Week the current wee starts from, the current year end dictates the end period of the current year. The same applies to the back book calculations.
For each of these periods defined by the start and end of the period I need to sum the volume for each record where the ISO week field falls into the range defined by the first table with start and end periods.
I can achieve this for one week using parameters easily but I need to be able to list week by week in order to create a comparison and then a graph of the data over time.
I hope this gives a little more information about what I am trying to achieve?"
End Result.docx 283.5 KB