a***m
发帖数: 666 | 1 不知道发在哪里好，就发这里了。这里能人多，能不能帮我一个忙。我正在学excel
VBA，今天遇到一个pivot table问题。The routine is to filter the page field
for the dates before 30 Nov 2013. But it doesn't work. The system pops up an
error message: object or application defined error. 可是我找死都找不到问题
在哪里。也许你们看到那个inputbox function 很奇怪。本来我想通过它输入一个日期
，然后pivot table根据输入的日期自动filter the pivot table。但是有问题。我就
用30/11/2013来测试。可惜还是没反应。愁呀，求大牛帮忙，不胜感激。
Sub Update()
Application.Calculation = xlCalculationManual
Worksheets("pivot").Select
ActiveSheet.Pivo... 阅读全帖 |
|
j*****n
发帖数: 1781 | 2 I had a solution but sounds stupid, post here see if anyone has better idea.
with Data (c1, c2, c3)
AS (
SELECT 's11', 's12', 's13'
union all
select 's21', 's22', 's23'
union all
select 's31', 's32', 's33'
union all
select 's41', 's42', 's43'
)
SELECT [1] r1, [2] r2, [3] r3, [4] r4
FROM
(SELECT c1, row_number() over (order by c1) as RN
FROM data) AS SourceTable
PIVOT
(
min(c1)
FOR rn IN ([1], [2], [3], [4])
) AS PivotTable
union all
SELECT [1] r1, [2] r2, [3] r3, [4] r4
FROM
(SELECT c2, row_... 阅读全帖 |
|
t*****g
发帖数: 2941 | 3 Right click on pivot table
choose PivotTable Options
click Display
check Classic PivotTable Layout
put mouse on "Item No Total", right click mouse
uncheck subtotal "Item No"
done! |
|
w*********g
发帖数: 30882 | 4 方舟子向南方系等媒体全面开炮 标签: 暂无标签
顶[2] 分享到 发表评论(0) 编辑词条
开心001
人人网
新浪微博
参见核心关联词条：西奴内讧,方舟子,剖析南方系
参见关联词条： 南方系沈亚川想让方舟子攻击王立军不遂即骂 南都的妓者编妓
为什么是臭的 《南方周末》的“普世价值”究竟是啥玩意？ 方舟子：《南方
周末》现在真是堕落了
http://t.sina.com.cn/1195403385/5em56CGfszT
@方舟子：有些记者把媒体当成了黑社会，把记者当成了打手。尤以南方报系的某些人
为甚。他们有圈子，没是非。有利益，没公道。还好意思挂着自由主义的招牌。//@
Fish哥: @方舟子 先生，这位记者@王卓铭 算是说出了他理解的新闻媒体的本质了，有
话语权就是牛，顺我者替你主持公道，逆我者一起让你没公道。 原文转发(319)|原文
评论(478)
http://bbs.anti-cnn.com/thread-288430-1-2.html
本月早些时候，网上曝出新华社记者采访家人的丑闻，眼里容不得沙子的方舟子赶
紧将此事转入... 阅读全帖 |
|
w********8
发帖数: 1 | 5 PRODUCT DESCRIPTION
You are bidding on a MICROSOFT OFFICE PROFESSIONAL 2010 FULL RETAIL NEW
Original Retail Price: $499.95
WHAT'S INCLUDED IN AUCTION
Includes the 2010 versions of Publisher, Excel, Outlook, OneNote, PowerPoint
, Access, and Word
Delivery Time
• Please allow for 6 to 10 business days(not counting weekends) for
it to arrive.
• We only have one delivery option (no Fedex shipping options).
• Item is new and never opened.
• It is delivered directly... 阅读全帖 |
|
发帖数: 1 | 6 需要英语沟通能力强，工作仔细认真, 主动积极。 很适合在美国没有工作经验的朋友。
感兴趣的话请把简历发到[email protected]
40hours/week in office
$14/hour with full benefits including health insurance, paid holidays and
paid time off
Excellent job opportunity to learn the project management skills and learn
Microsoft Speech Recognition technologies
Job Duties:
Coordinate efforts within the team and with global zh-CN/ en-GB/en-AU
resources efficiently
Perform review, auditing, and processing duties involving Natural Language
Processing Data wi... 阅读全帖 |
|
r*****e
发帖数: 4598 | 7 我是点一个格子的 filter咋能当search用尼 按字母排序？
真觉得excel功能挺强大的 光pivottable vlookup都有好多玩法 应该组团好好玩玩 |
|
t*****g
发帖数: 2941 | 8 Microsoft的support上是这个
http://support.microsoft.com/kb/929766
CAUSE
This issue occurs if the following conditions are true: The workbook
contains a...This issue occurs if the following conditions are true:
The workbook contains a PivotTable that uses key performance indicators (
KPIs).
The KPIs are created in the Analysis Services Business Intelligence
Development Studio.
One or more of the KPIs have an expression in the Current Time Member
property.
RESOLUTIONTo resolve this issue, remove the ex... 阅读全帖 |
|
A*******n
发帖数: 625 | 9 改一下 table t里面就可以了
select m,[Monday],[Tusday],[Wednesday],[Thursday],[Friday],[Saturday],[
Sunday]
from
(
select month('06/05/2014') as m,DATENAME(weekday,('06/05/2014')) as da,100
as sales) as t
pivot
(
sum(sales)
for t.da in ([Monday],[Tusday],[Wednesday],[Thursday],[Friday],[Saturday],[
Sunday])
) as pivottable |
|
n*****m
发帖数: 9872 | 10 有
excel里的pivottable和pivotchart就是做这个的。你的原始数据可以放在一个sheet里
，也可以储存在别的database里。数据更新后refresh一下就好了
★ 发自iPhone App: ChineseWeb 7.8 |
|
n*****m
发帖数: 9872 | 11 有
excel里的pivottable和pivotchart就是做这个的。你的原始数据可以放在一个sheet里
，也可以储存在别的database里。数据更新后refresh一下就好了
★ 发自iPhone App: ChineseWeb 7.8 |
|
l****z
发帖数: 29846 | 12 无意中说自己有些excel教程,所以好几个人都来要.
我想一个一个的传,不如干脆上传后给了link给大家.
里面有5本excel的书,希望对大家有用:
Apress.Beginning.PivotTables.in.Excel.2007.Sep.2007.pdf
financial_analysis_with_excel.pdf
Excel 2007 VBA Programming for Dummies.pdf
Excel Hacks- 100 Industrial-Strength Tips and Tools.chm
Excel 2007 Bible.pdf
其实这些书也是我从另外一个朋友的硬盘上"盗"来的, 所以密码就用了朋友的网名.
http://rapidshare.com/files/157467392/tmp.rar.html
password: coopers |
|
l****z
发帖数: 29846 | 13 无意中说自己有些excel教程,所以好几个人都来要.
我想一个一个的传,不如干脆上传后给了link给大家.
里面有5本excel的书,希望对大家有用:
Apress.Beginning.PivotTables.in.Excel.2007.Sep.2007.pdf
financial_analysis_with_excel.pdf
Excel 2007 VBA Programming for Dummies.pdf
Excel Hacks- 100 Industrial-Strength Tips and Tools.chm
Excel 2007 Bible.pdf
其实这些书也是我从另外一个朋友的硬盘上"盗"来的, 所以密码就用了朋友的网名.
到现在(2010年8月12日) 还看到有人要, 重新上传了.
更新了几个links,不知道是不是都能下. 大家试一试好了.
http://www.megaupload.com/?d=P0XHSA07
password: coopers
MD5 7c97a188c2066abb39e90fe8cbc6e2f9
SHA-1 3f394e1f7f4f5... 阅读全帖 |
|
I**********t
发帖数: 75 | 14 MM说得几点我都看了， 原来也都学过，应该不会考的很难吧。 Excel 我也只是把
lookup和pivottable准
备了，如果还要求编程，那个真是不会。 |
|
|
T******r
发帖数: 265 | 16 pivotTable 好象不行，我没想出来怎么实现。
能具体点吗？ |
|
l****z
发帖数: 29846 | 17 但我仔细看看, ACL里面的数据分析功能好像没有哪个是Excel里面做不到的吧. 而且
Excel里面要做到并不十分麻烦. 而同样Excel里面的pivottable, ACL要做那个, 太麻
烦了.
当然也不是说ACL一定不好, 主要是我现在感觉ACL那些人为了卖这个软件把ACL说的太
好了. 但仔细看看, ACL有很大的局限性. |
|
v********2
发帖数: 516 | 18 Behaviour Questions不好说，但是技术上，excel的技巧，pivottable等等，一些常用
公式之类可能会被问到。Peachtree，QB等的操作可能也会被问到。
Firm, |
|
b***k
发帖数: 2673 | 19 ☆─────────────────────────────────────☆
kangxiang200 (Sean) 于 (Thu Aug 14 10:37:24 2008) 提到:
Want to get exact same result as showed on the left on PivotTable sheet(see
the attachment).
I can't format it to exact same.
Thanks a lot!
☆─────────────────────────────────────☆
gap337 (Jobhunting) 于 (Thu Aug 14 11:13:37 2008) 提到:
If you are talking about hiding the extra sum lines on the bottom,
you can right click any of the bottom lines, right click choose field
settings,
and select "none" |
|
y****d
发帖数: 432 | 20 ★★★★★★★★★★★★★★★★★★★★★★★★★★★★★
前面说明：
需要的童鞋请到我的签名档的博客查找！谢谢！发E-mail太累了！
觉得有价值的话可以顶一下，以便更多的人看到！谢谢！
★★★★★★★★★★★★★★★★★★★★★★★★★★★★★
SAS2010全球论坛文章
1-10
Getting Connected to Your Data with SAS/CONNECT®
A Robust and Flexible Approach to Automating SAS® Jobs Under UNIX
Using SAS® Output Delivery System (ODS) Markup to Generate Custom
PivotTable and PivotChart Reports
Creating Easily Reusable and Extensible Processes: Code That Thinks for
Itself
ODS HTML Evolution, HTML that scrolls, panels, ... 阅读全帖 |
|
