+ Reply to Thread
Results 1 to 5 of 5

Display all data using a pivot or any other method

  1. #1
    Forum Contributor
    Join Date
    07-29-2009
    Location
    Melbourne, Australia
    MS-Off Ver
    Office 2010
    Posts
    184

    Display all data using a pivot or any other method

    I have the following sheet and with the idea to create a mail merge for each teacher workload

    I want to display all of the data from the data tab in the pivot table (or some other way) where I can then create the merge

    You can see Robert has a total of 27 units in the data but the pivot does not show repeated work loads showing only 17

    Q
    Attached Files Attached Files
    Last edited by pickslides; 11-30-2018 at 04:57 PM.
    Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind.

  2. #2
    Valued Forum Contributor ratcat's Avatar
    Join Date
    03-07-2008
    Location
    Rural NSW, Australia
    MS-Off Ver
    Vista 2007
    Posts
    1,092

    Re: Display all data using a pivot or any other method

    G'day,

    I may not able to help you from start to finish but wanting to get the ball rolling.

    Question. Mail merge is traditional MS Word, are just wanting MS Excel to do the lot ? Also the information you are distributing, how are you displaying it eg in the body of the email or as attachment in pdf, docx or xlsx format ?
    Have I made you happy ??? If yes, please make me happy by pressing the http://www.excelforum.com/images/buttons/reputation-40b.png Add Reputation button in my post.
    Please don't forget to do the same to other contributors of this forum.

    Thanks
    I don't void confusion, I create it

  3. #3
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016/Work 2013 Pro Plus
    Posts
    1,553

    Re: Display all data using a pivot or any other method

    You need to put Weekly Periods into the values area of the pivot table.

  4. #4
    Forum Contributor
    Join Date
    07-29-2009
    Location
    Melbourne, Australia
    MS-Off Ver
    Office 2010
    Posts
    184
    Quote Originally Posted by ratcat View Post
    G'day,

    I may not able to help you from start to finish but wanting to get the ball rolling.

    Question. Mail merge is traditional MS Word, are just wanting MS Excel to do the lot ? Also the information you are distributing, how are you displaying it eg in the body of the email or as attachment in pdf, docx or xlsx format ?

    Happy to use word for the merge but need to bring it into the document as a name and the table

  5. #5
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    5,951

    Re: Display all data using a pivot or any other method

    As it appears you intended to filter the pivot table to show only Robert's data, turning the range on the 'Data' sheet into a table and then filtering the 'Teacher' column (A) to show only Robert will display all of his data.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1