Pivot table calculation question
Results 1 to 2 of 2

Thread: Pivot table calculation question
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Oct 2017
    Posts
    19
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Pivot table calculation question

    I have a pivot table that looks like this

    Row Label Appointment Email Phone Call
    Joe 148 302 86
    Kate 129 88 303
    Ron 157 398 157
    Paul 125 221 47

    I want to have a column between each of Appointment, Email and Phone call that divides the count for Appointment Email or Phone Call by 48 (number of weeks in the period I am looking at).

    My fields are setup as follows
    Filters - none
    Columns - "Activity Type"
    Rows "Modified By"
    Values "Count of Regarding"

    I think I need a calculated field but, can't figure out the formula. Please help

    Thank You
    Jen

  2. #2
    New Member
    Join Date
    Aug 2019
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Pivot table calculation question

    You need to make 3 calculated fields each with the value field divided by 48.

    If you are trying to divide the count of the value field by 48. easy way is to add 3 columns in your data set using a If function to return zero or one. and use those fields in the pivot table calculated field function and divide by 48.

    I dont think count as a function works well in the calculated field. (ie. =count(field)/48)

    you can also make your pivot table a dynamic table by "offset" and "name" function so you can add more columns in the future without the need of creating new pivot table.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •