software

Is this possible? I'm starting with a pivot table with 2 data fields (Sales
and %Change). I have the data sorted by Sales, which is what I want. I
don't, however, want the Sales field to be displayed. When I hide the Sales
field, my sorting goes away. After further experimentation, I've found that
hiding a data field is nothing more than removing it from the pivot table.
Is there a way that I can only display %Change, but have my data sorted by
Sales?

Thanks!

Jeff


I have one simple question to u
How Can A pivot table be built with 2 fields?
one for row
second for column amp; third about data
which one is missing?

Lets assume 1) product Name as row, 2) month/year as column,
3) (i)sales amp; (ii) % change as data.

when I click the data (list box) amp; remove the tick of sales figure
there is no change in % change data. So I dont have problem at all.
every thing is all right.

Have I mis-understood u ? If yes plz explain again I will try again--
ExcelPower
------------------------------------------------------------------------
ExcelPower's Profile: www.excelforum.com/member.php...oamp;userid=30964
View this thread: www.excelforum.com/showthread...hreadid=508184The pivot table is laid out with 2 fields in the row area (Subdivion,
Region). I have 1 field in the column area (Item Category). Then, I began
with 2 fields in the data area (Sales and %Change). I want the Pivot Table
sorted by Item Category (with Item Category sorted in descending order based
on Sales). When both data fields are in the Pivot Table, I have no problem
having my Item Categories sorted in this way. The problem is that when I
hide the Sales field, the Item Categories go back to their default sorting of
alphabetical. I think the problem I'm finding is that when you hide a data
field, it really isn't hidden....it is removed. So I guess another way to
ask the question is: Can you sort a Pivot Table based on a data field that
is not actually in the Pivot Table. I'm guessing not, but I'd love to be
wrong.

Jeff

quot;ExcelPowerquot; wrote:

gt;
gt; I have one simple question to u
gt; How Can A pivot table be built with 2 fields?
gt; one for row
gt; second for column amp; third about data
gt; which one is missing?
gt;
gt; Lets assume 1) product Name as row, 2) month/year as column,
gt; 3) (i)sales amp; (ii) % change as data.
gt;
gt; when I click the data (list box) amp; remove the tick of sales figure
gt; there is no change in % change data. So I dont have problem at all.
gt; every thing is all right.
gt;
gt; Have I mis-understood u ? If yes plz explain again I will try again
gt;
gt;
gt; --
gt; ExcelPower
gt; ------------------------------------------------------------------------
gt; ExcelPower's Profile: www.excelforum.com/member.php...oamp;userid=30964
gt; View this thread: www.excelforum.com/showthread...hreadid=508184
gt;
gt;

Hi

You could always quot;cheatquot;.
Just mark the column containing the Sales datagt;Formatgt;Columngt;Hide

--
Regards

Roger Govierquot;goofy11quot; gt; wrote in message
...
gt; The pivot table is laid out with 2 fields in the row area (Subdivion,
gt; Region). I have 1 field in the column area (Item Category). Then, I
gt; began
gt; with 2 fields in the data area (Sales and %Change). I want the Pivot
gt; Table
gt; sorted by Item Category (with Item Category sorted in descending order
gt; based
gt; on Sales). When both data fields are in the Pivot Table, I have no
gt; problem
gt; having my Item Categories sorted in this way. The problem is that
gt; when I
gt; hide the Sales field, the Item Categories go back to their default
gt; sorting of
gt; alphabetical. I think the problem I'm finding is that when you hide a
gt; data
gt; field, it really isn't hidden....it is removed. So I guess another
gt; way to
gt; ask the question is: Can you sort a Pivot Table based on a data field
gt; that
gt; is not actually in the Pivot Table. I'm guessing not, but I'd love to
gt; be
gt; wrong.
gt;
gt; Jeff
gt;
gt; quot;ExcelPowerquot; wrote:
gt;
gt;gt;
gt;gt; I have one simple question to u
gt;gt; How Can A pivot table be built with 2 fields?
gt;gt; one for row
gt;gt; second for column amp; third about data
gt;gt; which one is missing?
gt;gt;
gt;gt; Lets assume 1) product Name as row, 2) month/year as column,
gt;gt; 3) (i)sales amp; (ii) % change as data.
gt;gt;
gt;gt; when I click the data (list box) amp; remove the tick of sales figure
gt;gt; there is no change in % change data. So I dont have problem at all.
gt;gt; every thing is all right.
gt;gt;
gt;gt; Have I mis-understood u ? If yes plz explain again I will try again
gt;gt;
gt;gt;
gt;gt; --
gt;gt; ExcelPower
gt;gt; ------------------------------------------------------------------------
gt;gt; ExcelPower's Profile:
gt;gt; www.excelforum.com/member.php...oamp;userid=30964
gt;gt; View this thread:
gt;gt; www.excelforum.com/showthread...hreadid=508184
gt;gt;
gt;gt;
Thanks for your time Roger and ExcelPower. It appears that I will have to
use a work around.

quot;Roger Govierquot; wrote:

gt; Hi
gt;
gt; You could always quot;cheatquot;.
gt; Just mark the column containing the Sales datagt;Formatgt;Columngt;Hide
gt;
gt; --
gt; Regards
gt;
gt; Roger Govier
gt;
gt;
gt; quot;goofy11quot; gt; wrote in message
gt; ...
gt; gt; The pivot table is laid out with 2 fields in the row area (Subdivion,
gt; gt; Region). I have 1 field in the column area (Item Category). Then, I
gt; gt; began
gt; gt; with 2 fields in the data area (Sales and %Change). I want the Pivot
gt; gt; Table
gt; gt; sorted by Item Category (with Item Category sorted in descending order
gt; gt; based
gt; gt; on Sales). When both data fields are in the Pivot Table, I have no
gt; gt; problem
gt; gt; having my Item Categories sorted in this way. The problem is that
gt; gt; when I
gt; gt; hide the Sales field, the Item Categories go back to their default
gt; gt; sorting of
gt; gt; alphabetical. I think the problem I'm finding is that when you hide a
gt; gt; data
gt; gt; field, it really isn't hidden....it is removed. So I guess another
gt; gt; way to
gt; gt; ask the question is: Can you sort a Pivot Table based on a data field
gt; gt; that
gt; gt; is not actually in the Pivot Table. I'm guessing not, but I'd love to
gt; gt; be
gt; gt; wrong.
gt; gt;
gt; gt; Jeff
gt; gt;
gt; gt; quot;ExcelPowerquot; wrote:
gt; gt;
gt; gt;gt;
gt; gt;gt; I have one simple question to u
gt; gt;gt; How Can A pivot table be built with 2 fields?
gt; gt;gt; one for row
gt; gt;gt; second for column amp; third about data
gt; gt;gt; which one is missing?
gt; gt;gt;
gt; gt;gt; Lets assume 1) product Name as row, 2) month/year as column,
gt; gt;gt; 3) (i)sales amp; (ii) % change as data.
gt; gt;gt;
gt; gt;gt; when I click the data (list box) amp; remove the tick of sales figure
gt; gt;gt; there is no change in % change data. So I dont have problem at all.
gt; gt;gt; every thing is all right.
gt; gt;gt;
gt; gt;gt; Have I mis-understood u ? If yes plz explain again I will try again
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; --
gt; gt;gt; ExcelPower
gt; gt;gt; ------------------------------------------------------------------------
gt; gt;gt; ExcelPower's Profile:
gt; gt;gt; www.excelforum.com/member.php...oamp;userid=30964
gt; gt;gt; View this thread:
gt; gt;gt; www.excelforum.com/showthread...hreadid=508184
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;