Improvements in Excel Pivot Table

[Guest]

I suggest three improvements in Excel Pivot Table.
1. We should be able to enter formula as we could in previous version. Like
relative and absolute address. Now if we want to add another column for
example to deduct expenditure from budget we have to do it line by line or
change it to values and do it. If we create new formulas, unnecessary data is
shown for each group/top level.

2. We should be able to sort by figures within Pivot table and be able to
add conditional formatting through menus.

3. The volume of data it currently manages is less. If we have records in
thousands, then Excel AutoFilter and Pivot Table cannot manage it.

Please let me know if it's not clear enough
--
Zubair Ezzat
Database Consultant
Kabul, Afghanistan
c+93) 70 29 09 29


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...f-bc7aa0453380&dg=microsoft.public.excel.misc

 

[Nick Hodge]

Zubair

1) You can add formulas in all versions of Excel pivot tables from the pivot
table toolbar. (Right click on any toolbar and select it and they're under
the pivot table drop-down

2) You can sort, by double-clicking on a row or column header and selecting
advanced.. here you will find auto-sort options. Conditional formatting is
not possible yet within the confines of a pivot table as it runs over if the
table is shortened or does not extend if lengthened

3) It will show 32,500 unique items per field in a pivot table. Honestly,
if you have more than this I would suggest a database. The autofilter is
limited to 254 unique items in the dropdown, but all are still selectable by
using custom...

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)

 

[Abobakr Nasr]

i want to calculate (year-to-year growth rate) in my pivot tale in MS
FrontPage 2003, i don't know how. But i read a massage here

http://groups.google.com/group/micr...ivot+table&rnum=8&hl=en&#doc_47a6960871bd36b2

that i can do it by Calculated Field feature in Frontpage (how?). My
equation for growth year ={ (X2 / X1) - 1 } *100
where X2 is the value of second year & X1 is the value of the first
one. Please, reply as quick as possible. Thanks a lot.

Abobakr Nasr
Database Designer
Cairo, Egypt

(e-mail address removed)

 

[Abobakr Nasr]

i want to calculate (year-to-year growth rate) in my pivot tale in MS
FrontPage 2003, i don't know how. But i read a massage here

http://groups.google.com/group/micr...ivot+table&rnum=8&hl=en&#doc_47a6960871bd36b2

that i can do it by Calculated Field feature in Frontpage (how?). My
equation for growth year ={ (X2 / X1) - 1 } *100
where X2 is the value of second year & X1 is the value of the first
one. Please, reply as quick as possible. Thanks a lot.

Abobakr Nasr
Database Designer
Cairo, Egypt

(e-mail address removed)

 

[Guest]

Dear Nick:
Thanks for the respond. I also believe we should use Access if we have more
records. But the issue of the formula is not supported in the current version
of ATLAS. For Example. If you have the Stock of Shoes and Icecream and you
have detail of how much/many you had in each location and how much is sold.
You make a formula of Balance=InStock-SoldOut. Now you didn't have any shoes
in USA, UK and UAE, but had it in Germany France and Russia. Because you
created a formula, all locations will be listed for both products. Now, in
earlier versions, you could make a formula in the column next to the pivot
table and could deduct SoldOuts from InStocks, but now, it uses PivotTable
functions if you use formulas (=). I'm not sure if you understood what I
mean. Otherwise, I can share a pivot table sheet with you. I don't know how
can I attach it here, perhaps email you if you want.
Zubair
--
==
Zubair Ezzat
Database Consultant
Kabul, Afghanistan
c+93) 70 29 09 29

 

[Debra Dalgleish]

You can prevent the GetPivotData formulas from appearing. There are
instructions here for adding the Generate GetPivotData button to a
toolbar, and toggling the feature on and off:

http://www.contextures.com/xlPivot06.html