Outdoorsman80
Board Regular
- Joined
- Oct 4, 2014
- Messages
- 62
- Office Version
- 365
- Platform
- Windows
I'm not sure if I titled this correctly or not. What I have is this:
A table of gold / silver purchases that contains: Purchase date, purchase price, value of silver at that time, amount, ounces, type. I created a nice Pivot table with slicers that let me break down the data a little more which is really handy.
What I want to do:
Have a field that I can enter the current value of gold / silver and have a formula calculate the # of gold/silver items with that field of current value. I'm not sure that I can do this with a Pivot table. Is that possible?
A table of gold / silver purchases that contains: Purchase date, purchase price, value of silver at that time, amount, ounces, type. I created a nice Pivot table with slicers that let me break down the data a little more which is really handy.
What I want to do:
Have a field that I can enter the current value of gold / silver and have a formula calculate the # of gold/silver items with that field of current value. I'm not sure that I can do this with a Pivot table. Is that possible?