software

(I’m hoping the table format is somewhat preserved in this post, so that the
question is readable...if not, I apologize!)

If I have a table structured like this:

ProductLineJanFebMar
ApplesRevenue500600600
ApplesProfit506060
OrangesRevenue400500400
OrangesProfit253525
PearsRevenue200200100
PearsProfit404020I can create a Pivot Table like this:ProductLineSumofJanSumofFebSumofMar
ApplesRevenue500600600
Profit506060
Apples Total550660660
OrangesRevenue400500400
Profit253525
Oranges Total425535425
PearsRevenue200200100
Profit404020
Pears Total 240240120
Grand Total 121514351205But I would also like to have the pivot table include rows near the bottom
for “Grand Total Revenue” and “Grand Total Profit” (rather than giving me the
Grand Total of Revenue Profit, which isn't meaningful).

Is this possible?Right click somewhere in the pivot table and select Table Options. In the Pivot Table Options dialog uncheck Grand totals for rows
and press OK.
Now click Pivot Table on the Pivot Table toolbar and select Formulas and Calculated Field. In the Name field write for example
Total. in the Formula field clear the 0, press Jan in theFields area and press Insert Field, enter a , press Feb, press Insert
Field, enter again a , press Mar and press Insert Field and OK.

Hansquot;TMorequot; gt; skrev i en meddelelse news
gt; (I'm hoping the table format is somewhat preserved in this post, so that the
gt; question is readable...if not, I apologize!)
gt;
gt; If I have a table structured like this:
gt;
gt; Product Line Jan Feb Mar
gt; Apples Revenue 500 600 600
gt; Apples Profit 50 60 60
gt; Oranges Revenue 400 500 400
gt; Oranges Profit 25 35 25
gt; Pears Revenue 200 200 100
gt; Pears Profit 40 40 20
gt;
gt;
gt; I can create a Pivot Table like this:
gt;
gt;
gt; Product Line SumofJan SumofFeb SumofMar
gt; Apples Revenue 500 600 600
gt; Profit 50 60 60
gt; Apples Total 550 660 660
gt; Oranges Revenue 400 500 400
gt; Profit 25 35 25
gt; Oranges Total 425 535 425
gt; Pears Revenue 200 200 100
gt; Profit 40 40 20
gt; Pears Total 240 240 120
gt; Grand Total 1215 1435 1205
gt;
gt;
gt; But I would also like to have the pivot table include rows near the bottom
gt; for quot;Grand Total Revenuequot; and quot;Grand Total Profitquot; (rather than giving me the
gt; Grand Total of Revenue Profit, which isn't meaningful).
gt;
gt; Is this possible?
gt;
Thank you for the response.

When I follow those steps, I get a Total column for Jan/Feb/Mar at the far
right of the table. What I'm looking for is a quot;Grand Total Revenuequot; and
quot;Grand Total Profitquot; at the bottom....so the left side of the PivotTable
would look something like:ProductLine
--------- -----
ApplesRevenue
Profit

OrangesRevenue
Profit

PearsRevenue
Profit

Grand Total Revenue
Grand Total ProftThe bottom two lines are the crux of what I'm looking for. I can only seem
to get one Grand Total line that adds both Revenue Profit, which isn't
meaningful.
quot;Hans Knudsenquot; wrote:

gt; Right click somewhere in the pivot table and select Table Options. In the Pivot Table Options dialog uncheck Grand totals for rows
gt; and press OK.
gt; Now click Pivot Table on the Pivot Table toolbar and select Formulas and Calculated Field. In the Name field write for example
gt; Total. in the Formula field clear the 0, press Jan in theFields area and press Insert Field, enter a , press Feb, press Insert
gt; Field, enter again a , press Mar and press Insert Field and OK.
gt;
gt; Hans
gt;
gt;
gt; quot;TMorequot; gt; skrev i en meddelelse news
gt; gt; (I'm hoping the table format is somewhat preserved in this post, so that the
gt; gt; question is readable...if not, I apologize!)
gt; gt;
gt; gt; If I have a table structured like this:
gt; gt;
gt; gt; Product Line Jan Feb Mar
gt; gt; Apples Revenue 500 600 600
gt; gt; Apples Profit 50 60 60
gt; gt; Oranges Revenue 400 500 400
gt; gt; Oranges Profit 25 35 25
gt; gt; Pears Revenue 200 200 100
gt; gt; Pears Profit 40 40 20
gt; gt;
gt; gt;
gt; gt; I can create a Pivot Table like this:
gt; gt;
gt; gt;
gt; gt; Product Line SumofJan SumofFeb SumofMar
gt; gt; Apples Revenue 500 600 600
gt; gt; Profit 50 60 60
gt; gt; Apples Total 550 660 660
gt; gt; Oranges Revenue 400 500 400
gt; gt; Profit 25 35 25
gt; gt; Oranges Total 425 535 425
gt; gt; Pears Revenue 200 200 100
gt; gt; Profit 40 40 20
gt; gt; Pears Total 240 240 120
gt; gt; Grand Total 1215 1435 1205
gt; gt;
gt; gt;
gt; gt; But I would also like to have the pivot table include rows near the bottom
gt; gt; for quot;Grand Total Revenuequot; and quot;Grand Total Profitquot; (rather than giving me the
gt; gt; Grand Total of Revenue Profit, which isn't meaningful).
gt; gt;
gt; gt; Is this possible?
gt; gt;
gt;
gt;
gt;

If you are interested (and you give me an e-mail address - can't use the one below) I can send you a workbook.
Hansquot;TMorequot; gt; skrev i en meddelelse ...
gt; Thank you for the response.
gt;
gt; When I follow those steps, I get a Total column for Jan/Feb/Mar at the far
gt; right of the table. What I'm looking for is a quot;Grand Total Revenuequot; and
gt; quot;Grand Total Profitquot; at the bottom....so the left side of the PivotTable
gt; would look something like:
gt;
gt;
gt; Product Line
gt; --------- -----
gt; Apples Revenue
gt; Profit
gt;
gt; Oranges Revenue
gt; Profit
gt;
gt; Pears Revenue
gt; Profit
gt;
gt; Grand Total Revenue
gt; Grand Total Proft
gt;
gt;
gt; The bottom two lines are the crux of what I'm looking for. I can only seem
gt; to get one Grand Total line that adds both Revenue Profit, which isn't
gt; meaningful.
gt;
gt;
gt;
gt; quot;Hans Knudsenquot; wrote:
gt;
gt;gt; Right click somewhere in the pivot table and select Table Options. In the Pivot Table Options dialog uncheck Grand totals for
gt;gt; rows
gt;gt; and press OK.
gt;gt; Now click Pivot Table on the Pivot Table toolbar and select Formulas and Calculated Field. In the Name field write for example
gt;gt; Total. in the Formula field clear the 0, press Jan in theFields area and press Insert Field, enter a , press Feb, press Insert
gt;gt; Field, enter again a , press Mar and press Insert Field and OK.
gt;gt;
gt;gt; Hans
gt;gt;
gt;gt;
gt;gt; quot;TMorequot; gt; skrev i en meddelelse news
gt;gt; gt; (I'm hoping the table format is somewhat preserved in this post, so that the
gt;gt; gt; question is readable...if not, I apologize!)
gt;gt; gt;
gt;gt; gt; If I have a table structured like this:
gt;gt; gt;
gt;gt; gt; Product Line Jan Feb Mar
gt;gt; gt; Apples Revenue 500 600 600
gt;gt; gt; Apples Profit 50 60 60
gt;gt; gt; Oranges Revenue 400 500 400
gt;gt; gt; Oranges Profit 25 35 25
gt;gt; gt; Pears Revenue 200 200 100
gt;gt; gt; Pears Profit 40 40 20
gt;gt; gt;
gt;gt; gt;
gt;gt; gt; I can create a Pivot Table like this:
gt;gt; gt;
gt;gt; gt;
gt;gt; gt; Product Line SumofJan SumofFeb SumofMar
gt;gt; gt; Apples Revenue 500 600 600
gt;gt; gt; Profit 50 60 60
gt;gt; gt; Apples Total 550 660 660
gt;gt; gt; Oranges Revenue 400 500 400
gt;gt; gt; Profit 25 35 25
gt;gt; gt; Oranges Total 425 535 425
gt;gt; gt; Pears Revenue 200 200 100
gt;gt; gt; Profit 40 40 20
gt;gt; gt; Pears Total 240 240 120
gt;gt; gt; Grand Total 1215 1435 1205
gt;gt; gt;
gt;gt; gt;
gt;gt; gt; But I would also like to have the pivot table include rows near the bottom
gt;gt; gt; for quot;Grand Total Revenuequot; and quot;Grand Total Profitquot; (rather than giving me the
gt;gt; gt; Grand Total of Revenue Profit, which isn't meaningful).
gt;gt; gt;
gt;gt; gt; Is this possible?
gt;gt; gt;
gt;gt;
gt;gt;
gt;gt;
Can you send me a workbokk with the solution to problem.

TIA
Oscar

Hans Knudsen ha escrito:

gt; If you are interested (and you give me an e-mail address - can't use the one below) I can send you a workbook.
gt; Hans
gt;
gt;
gt; quot;TMorequot; gt; skrev i en meddelelse ...
gt; gt; Thank you for the response.
gt; gt;
gt; gt; When I follow those steps, I get a Total column for Jan/Feb/Mar at the far
gt; gt; right of the table. What I'm looking for is a quot;Grand Total Revenuequot; and
gt; gt; quot;Grand Total Profitquot; at the bottom....so the left side of the PivotTable
gt; gt; would look something like:
gt; gt;
gt; gt;
gt; gt; Product Line
gt; gt; --------- -----
gt; gt; Apples Revenue
gt; gt; Profit
gt; gt;
gt; gt; Oranges Revenue
gt; gt; Profit
gt; gt;
gt; gt; Pears Revenue
gt; gt; Profit
gt; gt;
gt; gt; Grand Total Revenue
gt; gt; Grand Total Proft
gt; gt;
gt; gt;
gt; gt; The bottom two lines are the crux of what I'm looking for. I can only seem
gt; gt; to get one Grand Total line that adds both Revenue Profit, which isn't
gt; gt; meaningful.
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot;Hans Knudsenquot; wrote:
gt; gt;
gt; gt;gt; Right click somewhere in the pivot table and select Table Options. In the Pivot Table Options dialog uncheck Grand totals for
gt; gt;gt; rows
gt; gt;gt; and press OK.
gt; gt;gt; Now click Pivot Table on the Pivot Table toolbar and select Formulas and Calculated Field. In the Name field write for example
gt; gt;gt; Total. in the Formula field clear the 0, press Jan in theFields area and press Insert Field, enter a , press Feb, press Insert
gt; gt;gt; Field, enter again a , press Mar and press Insert Field and OK.
gt; gt;gt;
gt; gt;gt; Hans
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; quot;TMorequot; gt; skrev i en meddelelse news
gt; gt;gt; gt; (I'm hoping the table format is somewhat preserved in this post, so that the
gt; gt;gt; gt; question is readable...if not, I apologize!)
gt; gt;gt; gt;
gt; gt;gt; gt; If I have a table structured like this:
gt; gt;gt; gt;
gt; gt;gt; gt; Product Line Jan Feb Mar
gt; gt;gt; gt; Apples Revenue 500 600 600
gt; gt;gt; gt; Apples Profit 50 60 60
gt; gt;gt; gt; Oranges Revenue 400 500 400
gt; gt;gt; gt; Oranges Profit 25 35 25
gt; gt;gt; gt; Pears Revenue 200 200 100
gt; gt;gt; gt; Pears Profit 40 40 20
gt; gt;gt; gt;
gt; gt;gt; gt;
gt; gt;gt; gt; I can create a Pivot Table like this:
gt; gt;gt; gt;
gt; gt;gt; gt;
gt; gt;gt; gt; Product Line SumofJan SumofFeb SumofMar
gt; gt;gt; gt; Apples Revenue 500 600 600
gt; gt;gt; gt; Profit 50 60 60
gt; gt;gt; gt; Apples Total 550 660 660
gt; gt;gt; gt; Oranges Revenue 400 500 400
gt; gt;gt; gt; Profit 25 35 25
gt; gt;gt; gt; Oranges Total 425 535 425
gt; gt;gt; gt; Pears Revenue 200 200 100
gt; gt;gt; gt; Profit 40 40 20
gt; gt;gt; gt; Pears Total 240 240 120
gt; gt;gt; gt; Grand Total 1215 1435 1205
gt; gt;gt; gt;
gt; gt;gt; gt;
gt; gt;gt; gt; But I would also like to have the pivot table include rows near the bottom
gt; gt;gt; gt; for quot;Grand Total Revenuequot; and quot;Grand Total Profitquot; (rather than giving me the
gt; gt;gt; gt; Grand Total of Revenue Profit, which isn't meaningful).
gt; gt;gt; gt;
gt; gt;gt; gt; Is this possible?
gt; gt;gt; gt;
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;