Price Volume Mix Analysis Dashboard

[mrchristopher]

I am trying to create a dashboard to analyse Price Volume Mix between two periods of time that the user can select using sliders within the dashboard. I also want to maintain customer and product granularity. I'm trying to achieve a load that looks like the diagram below:

I'm having trouble doing this without creating loops or synthetic keys, does any one have any ideas?

[ahaahaaha]

Chris,

I apologize, I was wrong. I was baffled by your very first one diagram, from which I thought that several dates should be linked. The canonical dates here have nothing to do with your task.

As variant, may be use alternative states. The attached file shows an example of how to use them in the general context of your task. The use of alternative states can be somewhat inconvenient and you will not like it.

In any case glad if I could at least help you.

Regards,

Andrey