Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- monthly_sales =
- datasource("abc_corp",
- "strftime('%m/%d/%Y',Report_Date), sum(input) filter(Metric='Gross Sales' and Data_Type='Actual' and Year=2009 and Month=5)",
- "sum(input) filter(Metric='Gross Sales' and Data_Type='Budget' and Year=2009 and Month=5)",
- "sum(input) filter(Metric='Gross Sales' and Data_Type='Actual' and Year=2008 and Month=5)",
- "group by Report_Date")
Add Comment
Please, Sign In to add comment