+ Reply to Thread
Results 1 to 4 of 4

pivot table's many to one relationship.

  1. 10-14-2018, 10:55 AM #1
    saudi_red_neck
    saudi_red_neck is offline
    Forum Contributor
    Join Date
    03-12-2014
    Location
    Riyadh
    MS-Off Ver
    Office 365
    Posts
    129

    pivot table's many to one relationship.

    Hello friends, Hope all is well!

    Stuck with pivot table's many to one relationship. Can you please fix and teach me?

    I am basically trying to combine the data, i.e. the number of pizzas sold for dine in and delivery in 1 pivot table.

    Thank you & all the Best in advance!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 10-14-2018, 11:13 AM #2
    alansidman
    alansidman is offline
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,882

    Re: pivot table's many to one relationship.

    https://www.laptopmag.com/articles/e...from-multiples
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
    Reply With QuoteRegister To Reply
  3. 10-15-2018, 02:38 AM #3
    saudi_red_neck
    saudi_red_neck is offline
    Forum Contributor
    Join Date
    03-12-2014
    Location
    Riyadh
    MS-Off Ver
    Office 365
    Posts
    129

    Re: pivot table's many to one relationship.

    thank you but still struggling. I wish for the pivot table to show the results of both the Dine in and the Delivery: Based on the date and type of Pizza.
    Reply With QuoteRegister To Reply
  4. 10-15-2018, 06:05 AM #4
    stasinek
    stasinek is offline
    Valued Forum Contributor
    Join Date
    09-25-2015
    Location
    Nowy Tomysl, Poland
    MS-Off Ver
    2019, O365
    Posts
    398

    Re: pivot table's many to one relationship.

    Hello,
    Pay attention to the direction of relations between the tables
    Best wishes
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Power pivot relationship for date not working
    By AliAB in forum Excel Charting & Pivots
    Replies: 10
    Last Post: 07-22-2017, 05:07 PM
  2. Help on creating a correct Relationship between Power Pivot Tables
    By rv02 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-16-2016, 05:34 AM
  3. [SOLVED] Table Relationship vs SQL Join
    By dingdongsilver in forum Access Tables & Databases
    Replies: 6
    Last Post: 11-28-2014, 11:11 PM
  4. Pivot table not respecting relationship
    By wood923 in forum Excel General
    Replies: 8
    Last Post: 11-28-2014, 02:00 PM
  5. Creating Calculating Field on a pivot table from one-to-many relationship table sources
    By rezolutions24 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-09-2013, 12:32 PM
  6. [SOLVED] relationship table
    By pankaj8219 in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 01-07-2013, 09:33 AM
  7. Table relationship
    By ciprian in forum Access Tables & Databases
    Replies: 3
    Last Post: 08-31-2011, 07:24 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1