• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Pivot Table - calculated field that filters?

T

theath

New Member
I have a large amount of data that has been pulled from our company's time reporting system. I have a pivot table that shows the hours for selected resources, for selected activities.


I need to now show a calculated column on the report that displays "Available Hours". Available Hours will be the Hours (from above) minus PTO, Holiday, and Training Hours. These values are available in the raw data in a field titled Activity Title.


How do I write a formula so that this column subtracts from Hours the values in Activity Type that are equal to PTO, Training, and Holiday?


Confused Confused Confused :eek:/
 
Hi theath,


Can you give layout of your report + some sample data so that someone can try it out.


Faseeh
 
You must log in or register to reply here.
Back
Top