see the attached
since you did not include a twbx workbook the example is from super store using region and ship dates on a chart buile by sales and order date
it will return this
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.
ship date analogy.twbx 2.4 MB
How about adding that date filter to context:
Putting it to context moves it higher into the order of operations such that the date filter is applied before the LOD. More about context filters here:
Mavis - thanks so much for the recommendation. Using Context completely solved the problem. Sincerely, Art,