Using the example data above, I need to create a table that calculates "y" by Scenario like shown below. Column "y" should sum values from records where Scenario = 'hist' for all date stamps if the date stamp has data for the specific scenario and for scenario=hist. In this example, Scenario='a' only has data for Jan so the value for y does not include Feb data from Scenario='hist'. It is like joining the Scenario='hist' data to all the other scenarios by date stamp, but I need to do this in the visualization (not the script). Can this be done?
