+ Reply to Thread
Results 1 to 1 of 1

Split Sum of Value in Pivot Table using Multiple Tabs

  1. #1
    Registered User
    Join Date
    04-14-2014
    Location
    London
    MS-Off Ver
    Excel 2013
    Posts
    28

    Split Sum of Value in Pivot Table using Multiple Tabs

    Hi,

    I have created a Pivot table using multiple tabs (see the attached example). I would like to use the Top 3 Filter function, showing the top 3 "Items" by "Clicks", and not by the "Sum of Value" that use to calculate both columns, and showing the Top 3 considering the sum of "Clicks" and "Impressions".


    When I create the Pivot table using the same data, but across only one tab, under Values I have both, "Clicks" and "Impressions", and also when filtering by Top 3 I'm able to choose which one, "Items" by "Clicks", instead of "Items" by "Impressions".

    Thanks a lot!
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. pivot table placed in multiple tabs within a workbook?
    By Nick123456 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 09-14-2013, 01:39 AM
  2. Split excel into multiple tabs
    By kapil in forum Excel General
    Replies: 2
    Last Post: 07-14-2010, 02:19 AM
  3. Pivot table across multiple tabs in a workbook
    By mbrant in forum Excel General
    Replies: 4
    Last Post: 03-09-2007, 01:19 PM
  4. Split or Insert Into Multiple Tabs or Sheets
    By perkins2099 in forum Excel General
    Replies: 1
    Last Post: 01-11-2007, 09:07 PM
  5. Help: Create Pivot Table from multiple tabs in a Spreadsheet
    By AUDIOBLASTER in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-04-2007, 12:30 PM

Tags for this Thread

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