+ Reply to Thread
Results 1 to 1 of 1

Displaying % in Pivot Table on the same line issue...

  1. #1
    Registered User
    Join Date
    01-26-2019
    Location
    France
    MS-Off Ver
    2016
    Posts
    1

    Displaying % in Pivot Table on the same line issue...

    Hi team,

    Sorry for my poor grammar but english is not my mother tongue :-)

    I'm facing an issue displaying % in Pivot Table.
    If u have a moment, please take a look on my Pivot Table in attachment
    I would like to see % on the same line as my calculated field. This is a requirement and mandatory for my customer.
    Actually calculated fields and % are on different lines.
    I'm totally free to change the structure of the data source with VBA or Powerquery (depivot fields, etc...) but the final result must be a Pivot Table with % based on grand total of each measure (qty, revenue) like displayed in right side of my excel attachment (this is the final table for my customer).

    What i've done but unsuccessfully:
    - trying to use in a data model, transforming with OLAP formulas then adding manually % columns but result is definitively not a Pivot Table and not so esay to manage for my customer.
    - trying to add measures with PowerPivot but i'm not able to obtain the result expected for my client
    - playing with calculated fields in Pivot table but same issue
    - depivot each measure (qty, revenue) in Powerquery

    What i need to investigate:
    - changing the structure of my data source to be easily compliant with the final result.

    Any help would be greatly appreciated.

    All my best from France

    Phil
    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. New Pivot Table Displaying Old Data
    By johnallen876 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-13-2017, 08:29 PM
  2. Replies: 0
    Last Post: 10-10-2015, 09:51 AM
  3. pivot table from Power Pivot not displaying thousand separator/comma
    By Paul-NYS in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-04-2013, 01:05 PM
  4. Replies: 3
    Last Post: 09-20-2011, 05:02 AM
  5. displaying zeros when no value in pivot table
    By markcranmer in forum Excel General
    Replies: 1
    Last Post: 05-02-2010, 11:49 AM
  6. Displaying a average line on a pivot chart
    By excelaspire0219 in forum Excel General
    Replies: 2
    Last Post: 01-29-2009, 04:22 PM
  7. Displaying Pivot Table in IE
    By knapsack3 in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 01-22-2009, 05:21 AM

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