How to move values in Pivot table to the Rows section

How can I move Gross Revenue, Net Revenue and Net profit to the "Rows" section and have totals in the "values" section? Please see below:

Tax ID      (All)
Practice Name      (All)
      
Testing                                Total
Revenue A                     $150,000
Revenue B                     $250,000
Revenue C                     $350,000
Grand Total                     $750,000
LadkissonAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Saqib Husain, SyedEngineerCommented:
Is your question complete?
0
LadkissonAuthor Commented:
yes!
0
Saqib Husain, SyedEngineerCommented:
Where is the gross revenue?
Where is the net revenue?
Where is the net profit?

Can you upload a sample file?
And what you want the results to look like?
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

LadkissonAuthor Commented:
this is the traditional way of arranging data:

Tax ID      (All)            
Practice Name      (All)                  
                  
  Testing             Gross Revenue      Net Revenue      Net profit
Company A      $150,000                      $130,000              $20,000
Company B      $250,000                      $230,000              $20,000
Company C      $350,000                      $330,000              $20,000
Grand Total      $750,000                      $690,000              $60,000

And I need to have this:

Tax ID      (All)
Practice Name      (All)
      
      
Testing                      Total
Gross Revenue      $750,000
Net Revenue              $690,000
Net profit              $60,000
Grand Total              $1,500,000

Does this help?
0
Saqib Husain, SyedEngineerCommented:
I do not think this can be done. You might like to wait for some other expert. Why dont you simply use hlookup the get the desired table?

I can do some experiments if you upload a sample file with this data.
0
LadkissonAuthor Commented:
I've done this in the past but now I can't remember how to do it....
0
Saurabh Singh TeotiaCommented:
Can you post your sample file here as it becomes easy to work on it and provide a solution for this..Just post with dummy data please..

Saurabh...
0
LadkissonAuthor Commented:
Here you go and thanks!:)
Pivot-Table.xlsx
0
Saqib Husain, SyedEngineerCommented:
Is this what you are looking for?
Sample
0
LadkissonAuthor Commented:
how can I open this file?
0
Saurabh Singh TeotiaCommented:
Their you go i believe this is what you are looking for..

I created two calculated fields for you as well.

In additional in cost i'm counting charge as well in the cost you can go design and calculated items and see the formula and tweak it basis your requirements..

Saurabh...
Pivot-Table.xlsx
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
LadkissonAuthor Commented:
I figured this out as well:) But thank you so much for your help AGAIN!!:)
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.