Maybe your use case result here is not complex enough, but why not use the joined data, and a pill like AVG(Sales) instead of SUM(Sales)? AVG(Sales) would be much simpler, and just as effective in producing the same result that you have displayed here.
Do you need another level of aggregation, eg, joining at one level and aggregation to another? If so, then a table calculations would be a potential solution.
You're right Joe. One of the things I wanted to do here, was give solutions that could be published to data server, so someone without the knowledge of how this problem comes to be, can use the data without issue.
I wanted the solution to exist, without having to build anything (blending aside).
Hopefully this chain will be useful to people.
> " so someone without the knowledge of how this problem comes to be, can use the data without issue."
That is an interesting approach, and that was useful to me, thank you!
Sorry for going off topic here, I couldn't figure out how to message you via the forums directly.
Do you have any materials that you could share with me from the Jedi Marks presentation that you did for the TCC 2013 DC?
I had to leave midway through the last session and was expecting to be able to view the recorded session later on, but was unable to locate it.
If you can help, please email firstname.lastname@example.org