Hi see the attached
first Total() is a table calculation so when you used to to calculate a % it becomes aa table calc
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
LOD Help Needed_v10.3.twbx 1.2 MB
2 of 2 people found this helpful
Hey Jim - I appreciate the quick response and this got me to the correct answer with the final output being:
Only issues I saw with your solution:
1) "Avg. Weighted Time to Ship" has a total when you unfiltered of 199.8. I think the measure needs to be changed to average, but even that doesn't get the correct answer because it is coming up with 4.077 when state is fixed, where i think the true weighted average across all sales is 3.923.
2) The "Weighted Credit Terms as Part of Total" column should equal the 2nd column if done correctly as this is just showing each states contribution to the overall weighting.
this is what the unfiltered version I was looking for is: