+ Reply to Thread
Results 1 to 2 of 2

Need for a pivot table in the subtotal row the sum of column with averages.

  1. #1
    Registered User
    Join Date
    03-31-2021
    Location
    As, Belgium
    MS-Off Ver
    O365
    Posts
    6

    Need for a pivot table in the subtotal row the sum of column with averages.

    Hello,

    I need some help with totals and subtotals in a pivot table
    I want that the subtotal row of a column with averages the sum is of the items and not the average of the items.
    I attachment you can find in one tab the data and in the other tab the pivot table.
    In the last three columns the value is the average. The rows are two lines days and RF.
    For each day there is a subtotal of three RF lines.
    There are 9 columns. The first 6 rows are sums, the last three are averages.
    For the subtotal of the day the sum of the three RF for each column has to be made.
    For the first six columns there is no problem. For the last three i get in the subtotal line the average of the 3 RF items and not the sum and i need the sum.

    Can someone tell me how i can solve this ?

    Thank You in advance.

    Marc.
    Attached Files Attached Files

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent SAC
    Posts
    8,887

    Re: Need for a pivot table in the subtotal row the sum of column with averages.

    Do you mean like this? It uses PowerPivot with a few added measures - three simple averages, then three that use either the simple average, or the sum of the simple averages, depending on where the field is.
    Attached Files Attached Files
    Rory

+ 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. Replies: 4
    Last Post: 03-19-2021, 03:06 PM
  2. [SOLVED] Sort Pivot Table by Column Subtotal
    By Tayque_J_Holmes in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 04-20-2016, 02:08 PM
  3. Replies: 4
    Last Post: 03-13-2015, 05:34 AM
  4. Keeping subtotal averages in a changing sorted table
    By JesseKelson in forum Excel General
    Replies: 1
    Last Post: 08-27-2014, 12:51 PM
  5. Replies: 9
    Last Post: 05-15-2014, 01:57 PM
  6. [SOLVED] Marco for pivot table like fuctions. Subtotal column C, based on column B criteria.
    By RobertOHare in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-09-2013, 02:57 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