Forum Discussion
Show Values Between STRT and STOP values not working
Not quite there yet but thank you for your help.
You are super close! 😊
The data contains different components. The overlapping data should sum. For example:
Here are two components of the data separated. There are more components to the data but I show two for simplicity.
When the same two components are combined there are two display possibilities:
1) My Requirement: The overlapping data is summed and all values between STRT and STOP are displayed for each separate component. Notice the sum of 2 in the overlapping cell. The black area is the non-overlapping data and the sum of these cells are 1.
(I manually constructed the example below)
2) With the Measure solution you provided only the overlapping areas are displayed and all the values between STRT and STOP are not displayed for each separate component.
Notice the sum of 1 in the overlapping cell. All overlapping components are sum of 1.
Hope that makes sense.
I'm still stuggling with the measure. I'm sure it's something simple but I have not figured it out yet.
Thank you....