1) Create a prompt day week and declare presentation variable
2) Here is the report ,i pulled product and booked qty
To show 30days back booked quantity the date selected in prompts
In fx use
FILTER("Facts Other"."Booked Qty" USING (Time."Day Date"=TIMESTAMPADD(SQL_TSI_DAY, -30, DATE '@{day}')))
To show 30days back booked quantity the date selected in prompts
In fx use
FILTER("Facts Other"."Booked Qty" USING (Time."Day Date"=TIMESTAMPADD(SQL_TSI_DAY, -30, DATE '@{day}')))
You can apply the same formula for 1....n days
For month level use
FILTER("Facts Other"."Booked Qty" USING (Time."Day Date"=TIMESTAMPADD(SQL_TSI_MONTH, -3, DATE '@{month}')))
where -3= three months back
For month level use
FILTER("Facts Other"."Booked Qty" USING (Time."Day Date"=TIMESTAMPADD(SQL_TSI_MONTH, -3, DATE '@{month}')))
where -3= three months back
Reposted from saichand varanasi
Thanks
1 comments:
Hi
Thanks for the blog..
I need a help IF need to display the day leve data i.e . -30 is displaying data with single record.. But if we want to display about each day between current dat and 30th day.. how can we achive it.
thanks
sid
Post a Comment