Results 1 to 2 of 2

Add dual value to Pivot table report

Threaded View

  1. #1
    Forum Contributor
    Join Date
    10-08-2014
    Location
    Bengaluru, India
    MS-Off Ver
    O 365
    Posts
    141

    Add dual value to Pivot table report

    How to add two different values in a Pivot table , one at the project level and the other at the subproject level.

    I have Project and Sub Project (Work order) in rows and month number in columns. What i want to do is add Project Level multiplier to Project row and Sub Project level multiplier to Sub Project row, but if i add two values in the values section, Matrix visual is creating different column for the second value section, is there anyway i can add different values to different level rows
    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. [SOLVED] Dynamic report table using pivot table as its data source
    By jarrgonn in forum Excel General
    Replies: 3
    Last Post: 01-26-2021, 01:23 PM
  2. Replies: 0
    Last Post: 07-14-2016, 03:51 PM
  3. Pivot Report doesn't show current records but they are in pivot table
    By dixiecricket in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 06-16-2015, 11:25 AM
  4. Replies: 0
    Last Post: 11-18-2011, 07:31 AM
  5. Replies: 0
    Last Post: 02-23-2011, 08:50 AM
  6. a pivot table report cannot overlap another pivot table report
    By judyh in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-25-2007, 12:59 AM
  7. [SOLVED] A pivot table report cannot overlap another pivot table report.
    By David in forum Excel General
    Replies: 1
    Last Post: 06-23-2005, 07:05 PM

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