Hello Friends,
Trying to figure this out but having trouble.
I have a chart that shows In Force policies by Broker for the current period and the year before. Like so
Broker Name 2016-06 2017-06
A 500 600
B 200 300
and so on...
I have this set up by assigning a variable vCurrentDate as the current date and the year before is calculated as AddYears(vCurrentDate,-1). This is a calculated dimension set up as
if(InforceDate = $(vCurrentDate) or InforceDate = AddYears(vCurrentDate,-1), InforceDate)) and then suppress null values.
The issue is that the data is coming from two different systems. System 1 is updated as of June 2017 but System 2 is as of May 2017 and will not update until 15th business day. So currently in the chart above, if say Broker C is from system 2, it will show 0 under 2017-06.
So no problem with System 1 but how do I modify the calculated dimension so that it shows 2016-05 and 2017-05 if a user selects a broker that happens to come from System 2?
Should I be using set analysis instead of calculated dimensions? I feel this may be simple but confused.
Any help is appreciated.
Shariq
