My situation is that I want to display something of a switch with dates in a combo chart (bars and lines).
If the switch is in the 'A' position, I want to display the values that are in the lastfile or data set I received for each month from the previous XX months. If in the 'B' position, I want to display all of the values from the files that I received in the current month.
With Apr as my current month:
Switch A: Jan Feb Mar Apr
Switch B: 1Apr 7Apr 10Apr 29Apr
And then when May comes around, Switch A would include May, Switch B would be the files loaded in May. No selections or filtering at this stage. But, let me expand this just a bit as I am thinking for Switch B would be dedicated to show the files loaded in a 'selected' month (I don't want to say drill down but, in essence, that is what is being done.).
I currently have two date fields in my table. One being the LoadDate (YYYYMMDD) and the other being the LoadMonth (YYMMM). I have one variable to capture the current month.
What would be the expression to filter the last file's values for a month to satisfy Switch A? Is this possible?
What would be the expression to filter the data for the current month to satisfy Switch B? Is this possible? = Sum({1<LoadMonth = {"='=vCurrentMonth'"}>} X - Y - Z) I started with the above expression, but this now doesn't return anything. I tried to filter or parse the LoadMonth with Date(Date#(LoadMonth,'YYMMM'),'YYMMM') but this didn't help. What I am doing wrong here?
