Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everybody,
Do you know how to do a MTD table in sript??
I have the following table and I need a NUM_SALES_MTD field
Table 1:
NUM_SALES,
PROVIDER_ID,
MARKET_ID,
DATE,
YEAR,
MONTH,
WEEK ;
If I'd have only one dimension I could use peek function but I need the other dimensions...
I have tried to make the expressions at the layout but it seems to require a lot of memory...(I have a lot of expressions and the system can't support the calculation)
any Idea?
regards,
David
If (YEAR= YEAR(today() and MONTH = Month(today(),NUM_SALES) as NUM_SALES_MTD
then just sum(NUM_SALES_MTD) in charts etc
Hi,
You need to create a MTD column by creating a field like
If ( Year = Year(Today()) and Monthend( today() ) , NUM_SALES) as MTD_Sales
Regards,
Anand
Hi,
I think you want group by here.
say :
load sum ( NUM_SALES ) as Num_Sales_MTD,
PROVIDER_ID,
MARKET_ID,
DATE,
YEAR,
MONTH,
WEEK
from <Your>.qvd
group by YEAR, MONTH;
HTH