Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all,
Am facing the issue in expression can any one correct me? in pivot table
thanks in advance
i dnt hve master calender....
my script lik dis:
LOAD
PRJ_NUMBER,
PERIOD_NAME,
BALANCE_ACTUAL,
BALANCE_BUDGET,
PERIOD_YEAR,
Year(PERIOD_YEAR) as CYear,
Month(PERIOD_YEAR) as CMonth,
Date(PERIOD_YEAR) as CDate,
PERIOD_NUM,
PRJ_BU
FROM [lib://Management/MANAGEMENT_PACK.QVD]
(qvd);
current month- Sum({$<Month = {$(=Max(Month))},Year = ,Quarter = ,Month = >} BALANCE_ACTUAL)
6months[til jun'15] -- Sum({<Month = {"<=$(=max(Month, 6))"},Year = {$(=(max(Year)-1))} >}BALANCE_ACTUAL)
Ytd[til dec'15- Sum({<Year=, Month=, Quarter=, Week=, DateField=, DateNum={">=$(=Num(YearStart(Max(DateNum))))<=$(=Max(DateNum))"}>} BALANCE_ACTUAL)
where am geting wrng values so kindly help me out where am getting problem
thanks
suresh
thanks sasi...
let u give me a time...because user needs to chnge the data to existing one and some other caluclation once i get complete data....i will compare both the sets.and let u know.
Thanks alot fr ur response....
Suresh.
thanks alot for ur solution.. that is correct but need chnges done .....much appreciated.
Thanks
Suresh