Using a Defined Name Value in a Pivot Table

R

Ronster

I'm trying to create a calculated field in a pivot table that tells
me how many weeks are remaining in the current yearly quarter. For
example if the date is April 7th, I know I am in the 2nd Quarter of the
year and there are 12 weeks remaining in this quarter (13 weeks - 1).
I can calculate this ok OUTSIDE of the Pivot Table and even give it a
DEFINED NAME, like Weeks_Remaining but I don't know whether I can use
the defined name in a calculated field inside a pivot table. Any help
would be appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with a Pivot Table (when I don't want to) 0
Doughnut Chart linked with the slicer in the pivot table 0
How I can set dynamic pivot table ONLY when I have enough data point 1
Pivot Table Management 4
Batch Pivot Table update 0
VBA Pivot Table: Determining item from one field based on anotherfield item 0
Playing back a Pivot Table macros 2
Selecting Date Range in a Pivot using VBA 0

Top