FORECAST VS PREVIOUS with a ASOFTABLE

[philgood34]

Hi Everybody

I have a asoftable in my loading script

I have a measure called CATTC (instead of "SALES")

In a tab, i want to have a comparaison between FORECAST CATTC and PREVIOUS YEAR

for all the next year

 

My issue :

As you can see,  when the current datas are not yet imported (since February), the previous datas are not shown while they are there.

Here is my expression :

For the previous year datas 

Sum({<Flag = {'PY'}>}VMS_CATTC)

for the forecast datas

Sum({<Flag = {'GOAL'}>}VMP_CATTC)

An idea to solve my issue ?

thanks in advance

REGARDS

Philippe

[philgood34]

Hi everybody, Sunny & Agni

I created a new sample app. containing my issue, I hope it will be clearer

unfortunately, I can not  attach my file app (sample.qvf) ??? 

i read this message :

                                             The contents of the attachment doesn't match its file type.

can you help me please ?

Best regards

Philippe

[philgood34]

I try to attach my files as a zip one

[philgood34]

GOT IT !

[sunny_talwar]

So, is your issue resolved? or do you still need help?

[philgood34]

No resolved

i sent a app with sample to offer better explanation

did you saw it  ?

regards

Philippe