Forum Discussion
problem with calculation-many to many
hi Dale,
thank you very much!
this is the sample
reminder: orig=1 means weekly data: 04/01 is 04/01 to 04/07
orig=2 means 28 days - 04/01 is 04/01-04/28
thanks!
Hi,
I am so sorry I still can’t make out the whole thing. But we can solve it step by step. I made a little mode with your sample.
1. Is this similar with yours?
2. Which columns in your sample are to be used?
3. What does the "measure X" mean? Can you post the formula if it has one.
4. Please have a look at the image in the bottom. Is this what you want? Or you can privide a sample visual.
Best Regards!
Dale
Hi,
I am so sorry I still can’t make out the whole thing. But we can solve it step by step. I made a little mode with your sample.
1. Is this similar with yours?
2. Which columns in your sample are to be used?
3. What does the "measure X" mean? Can you post the formula if it has one.
4. Please have a look at the image in the bottom. Is this what you want? Or you can privide a sample visual.
Best Regards!
Dale
thank you!
this is the solution i tried, but i was mistaken with the relationship
thanks!!!