Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I want to calculate previous 12 months of Sales in Script level (In script level ).
Then after , I want to show that field in Table View .....
Thanks
Madhu
Are you looking to sum last 12 months for each row of data? Can you share some data?
Hi Sunindia,
I'm already calculated the previous 12 months in script level.....
But , I want to show that calculated field in Table view.....
How can we achieve this one .......
Thanks for your reply...
Thanks
Madhu
You have already calculated it??? I am not sure what you are looking for, would you be able to share a sample?
Best,
Sunny
If(date(floor(Date))> AddMonths(Today(), -12), 1) AS Last12Month
Try this,
SUM({$<FinancialYear=,MonthName=,FiscalYear={$(=max(FiscalYear)-1)},Quarter=
,[Date]={">=$(=MonthStart(max({$<FiscalYear={$(=max(FiscalYear))}>}[Date]),-12))<=$(=addmonths(max({$<FiscalYear={$(=max(FiscalYear))}>}[Date]),-12))"}>}[Sales])
in UI-->sum({<=$(Max(year))-1>}sales) or sum({<=$(Max(month))-12>}sales)
in script level-->use if() condition
Hi Pratap budati
i am already done with calculation in script level .......but i want to show in table view....how can we acheive?
Hi Madhu,
If you have this field in script, then it will appear in table viewer.
Try to do a resident load of that table and drop the actual table and see if you can see that field in table viewer.
Regards
Jyothish KC