交叉表报告中的动态每周日期范围 [英] Dynamic weekly date range in crosstab report
本文介绍了交叉表报告中的动态每周日期范围的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
你好,
我正在使用动态交叉表报告来跟踪我公司的性能统计数据,我遇到了问题。
我想选择每天(最近7天),每周(过去6周)和每月(过去6个完整月份)跟踪统计数据。
每日并且每月不会导致我出现问题 - 我使用以下代码构建查询:
Hello,
I am using a dynamic crosstab report to track performance statistics for my company and I have hit a problem.
I would like the option to track stats daily (for the last 7 complete days), weekly (for the last 6 weeks) and monthly (for the last 6 complete months).
Daily and monthly are not causing me a problem - I have used the following code to construct the query:
< span class =codeLinkonclick =Blur(this,this.parentNode.parentNode,getChildren(this),true);>展开 | 选择 | Wrap | 行号
推荐答案
只是有点碰撞!谁能帮我这个?请....?
Just a little bump! Can anyone help me with this? Please....?
怎么样[日期] BETWEEN(EndDate-42)和EndDate
What about [DATE] BETWEEN (EndDate - 42) AND EndDate
谢谢筹码,但这会给我一个6周日期范围内每天的每日总计(如果在数据透视中使用)。我所追求的是每周6周的总计。
还有其他想法吗?
非常感谢
Thanks Chip, but that would give me a daily total for each day in the 6 week date range (if used in the pivot). What I''m after is a weekly total for each of 6 weeks.
Any other ideas?
Many thanks
这篇关于交叉表报告中的动态每周日期范围的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文