Results 1 to 5 of 5

Customized Subtotal in Pivot

Threaded View

  1. #1
    Registered User
    Join Date
    08-15-2022
    Location
    Los Angeles
    MS-Off Ver
    365
    Posts
    12

    Customized Subtotal in Pivot

    Hi Team,
    I have a couple of challenges for you.
    1. I want to show subtotals and totals in a pivot table. The subtotals shown here were added via right click "add subtotals". For column 4,5,6 works fine but for columns 7 and 10 it doesn't. Is there a way I can create an object/measure to mimic the formula in N34 and in O34?
    2. I have a Filter Return by type because the complete data has different return Types. So, the solution should considered that this selection will change.
    Thanks.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Working with a pivot table and added customized columns
    By Scizzy in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-10-2020, 06:07 PM
  2. [SOLVED] Customized/external icons for customized ribbon
    By aprildu in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-31-2019, 04:28 AM
  3. DISPLAY SUBTOTAL and SUBTOTAL % in PIVOT TABLE
    By excelmr in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-11-2015, 05:44 AM
  4. need macro to create a customized pivot in new sheet
    By saidineshbabu in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-02-2013, 01:35 PM
  5. Customized Layout/format for Pivot table
    By aicheng in forum Excel General
    Replies: 0
    Last Post: 08-16-2011, 01:03 AM
  6. Customized Pivot Chart
    By Kumara_faith in forum Excel General
    Replies: 4
    Last Post: 06-16-2010, 11:16 PM
  7. [SOLVED] Pivot Table Customized Views
    By kza40381 in forum Excel General
    Replies: 6
    Last Post: 09-19-2005, 10:05 AM

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