software

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 quot;I
Agreequot; 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 quot;I Agreequot; in the message pane.

www.microsoft.com/office/comm...lic.excel.misc

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
HISquot;Access4Afghanquot; .(donotspam)gt; wrote in message
...
gt;I suggest three improvements in Excel Pivot Table.
gt; 1. We should be able to enter formula as we could in previous version.
gt; Like
gt; relative and absolute address. Now if we want to add another column for
gt; example to deduct expenditure from budget we have to do it line by line or
gt; change it to values and do it. If we create new formulas, unnecessary data
gt; is
gt; shown for each group/top level.
gt;
gt; 2. We should be able to sort by figures within Pivot table and be able to
gt; add conditional formatting through menus.
gt;
gt; 3. The volume of data it currently manages is less. If we have records in
gt; thousands, then Excel AutoFilter and Pivot Table cannot manage it.
gt;
gt; Please let me know if it's not clear enough
gt; --
gt; Zubair Ezzat
gt; Database Consultant
gt; Kabul, Afghanistan
gt; c 93) 70 29 09 29
gt;
gt;
gt; ----------------
gt; This post is a suggestion for Microsoft, and Microsoft responds to the
gt; suggestions with the most votes. To vote for this suggestion, click the quot;I
gt; Agreequot; button in the message pane. If you do not see the button, follow
gt; this
gt; link to open the suggestion in the Microsoft Web-based Newsreader and then
gt; click quot;I Agreequot; in the message pane.
gt;
gt; www.microsoft.com/office/comm...lic.excel.misc
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

groups.google.com/group/micro...a6960871bd36b2

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 amp; X1 is the value of the first
one. Please, reply as quick as possible. Thanks a lot.

Abobakr Nasr
Database Designer
Cairo, Egypt

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

groups.google.com/group/micro...a6960871bd36b2

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 amp; X1 is the value of the first
one. Please, reply as quick as possible. Thanks a lot.

Abobakr Nasr
Database Designer
Cairo, Egypt

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
quot;Nick Hodgequot; wrote:

gt; Zubair
gt;
gt; 1) You can add formulas in all versions of Excel pivot tables from the pivot
gt; table toolbar. (Right click on any toolbar and select it and they're under
gt; the pivot table drop-down
gt;
gt; 2) You can sort, by double-clicking on a row or column header and selecting
gt; advanced.. here you will find auto-sort options. Conditional formatting is
gt; not possible yet within the confines of a pivot table as it runs over if the
gt; table is shortened or does not extend if lengthened
gt;
gt; 3) It will show 32,500 unique items per field in a pivot table. Honestly,
gt; if you have more than this I would suggest a database. The autofilter is
gt; limited to 254 unique items in the dropdown, but all are still selectable by
gt; using custom...
gt;
gt; --
gt; HTH
gt; Nick Hodge
gt; Microsoft MVP - Excel
gt; Southampton, England
gt; www.nickhodge.co.uk
gt; HIS
gt;
gt;
gt; quot;Access4Afghanquot; .(donotspam)gt; wrote in message
gt; ...
gt; gt;I suggest three improvements in Excel Pivot Table.
gt; gt; 1. We should be able to enter formula as we could in previous version.
gt; gt; Like
gt; gt; relative and absolute address. Now if we want to add another column for
gt; gt; example to deduct expenditure from budget we have to do it line by line or
gt; gt; change it to values and do it. If we create new formulas, unnecessary data
gt; gt; is
gt; gt; shown for each group/top level.
gt; gt;
gt; gt; 2. We should be able to sort by figures within Pivot table and be able to
gt; gt; add conditional formatting through menus.
gt; gt;
gt; gt; 3. The volume of data it currently manages is less. If we have records in
gt; gt; thousands, then Excel AutoFilter and Pivot Table cannot manage it.
gt; gt;
gt; gt; Please let me know if it's not clear enough
gt; gt; --
gt; gt; Zubair Ezzat
gt; gt; Database Consultant
gt; gt; Kabul, Afghanistan
gt; gt; c 93) 70 29 09 29
gt; gt;
gt; gt;
gt; gt; ----------------
gt; gt; This post is a suggestion for Microsoft, and Microsoft responds to the
gt; gt; suggestions with the most votes. To vote for this suggestion, click the quot;I
gt; gt; Agreequot; button in the message pane. If you do not see the button, follow
gt; gt; this
gt; gt; link to open the suggestion in the Microsoft Web-based Newsreader and then
gt; gt; click quot;I Agreequot; in the message pane.
gt; gt;
gt; gt; www.microsoft.com/office/comm...lic.excel.misc
gt;
gt;
gt;

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:

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