Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
When you took the snapshot of the chart, were you making selection in any date and time related fields? or any other fields?
I explain :
in my snapshot, you see the current datas over the périod November to January.
of course, i made the forecast for all the period (11/2018 to 10/2019)
and of course, the prévious data are known and imported
But as you see, previous data only appear if current datas are present ???
I would like the previous datas to be visible in the table over the entire period, even if the current data is not yet imported
here :
Sunny ,
I just selected the fiscal year (11/2018 to 09/2019)
Can you try this
Sum({<Flag = {'PY'}, [fiscal year]>}VMS_CATTC)
and let us know what do you see?
LIKE THIS
no other selection
This may give you everything for previous year expression... but that will help determine the issue and we can work on it further
So the name of the field is EXERCISE? Try this
Sum({<Flag = {'PY'}, [EXERCISE]>}VMS_CATTC)
I tried
Sum({<Flag = {'PY'}, fYear>}VMS_CATTC)
no change