2 of 2 people found this helpful
You can do this with LOD, I can see you were on the right track with the min week field you created. So what I did was create and additional field I called Distinct Part Number, the formula is below. I also added the area filter to context, alternatively you can add area to the min week lod. Let me know if you have any questions.
1. Create Distinct Part Number: IF [WEEK] = [min_week_part_number] THEN [PART_NUMBER] END
2. Add area filter to context
3. Create your running sum: RUNNING_SUM(COUNTD([Distinct Part Number]))
thanks a lot. it worked exactly as i wanted