Pivo table functions

E

ejgallagher

Board Regular
Joined
Aug 3, 2002
Messages
123
Hi All,

I am having trouble with an aspect of pivot tables. I am extremely familiar with the process of pivots but this is killing me.

I have the a data I want to see - in this case sums of money in two separate columns. I also want to compare these sums - 1 as a percentage of the other. I am using the function in the options sections for this but I keep getting a #N/A value. Both columns are formatted for currency so I can't figure out the problem!

Your help is appreciated!

Thanks,

Ed
 

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.
Sort by date Sort by votes
I see that you haven't received other answers to your question, so far. If you would be so kind as to present an example, taken directly from your data, with, say, the first three rows of your two-column data, plus the "Options" column, with your formula, then, I'm sure, we could stop batting our brains against the wall trying to outguess you. We are NOY, repeat, NOT, mind readers, as so many posters seem to believe!
 
Upvote 0
You must log in or register to reply here.

Similar threads

B
  • Question
Excel 2021 - Building a Pivot Table on a Filter Function Array
Replies
9
Views
318
BrerRabbit
B
A
  • Solved
Pivot Table Sum giving Zeros but count works
Replies
5
Views
706
RoryA
RoryA
S
  • Question
Repeating a pivot table many times and changing only one column -- are there more efficient approaches?
Replies
0
Views
221
sschaefer
S
M
  • Question
Sum of field in pivot table
Replies
0
Views
172
mabubakerali
M
B
  • Question
TEXT function and Data Table issue
Replies
2
Views
171
bigleauge123
B

Forum statistics

Threads
1,215,872
Messages
6,127,430
Members
449,382
Latest member
DonnaRisso

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top