Results 1 to 2 of 2

Thread: Adding Calculated Field with multiple Columns
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    May 2019
    Location
    Virginia
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Adding Calculated Field with multiple Columns

    Hello,

    Is there any way to create a calculated field when there is multiple columns in pivot table?
    there is two fields inserted in to column section and use the number from there to create calculated field.

    I am trying to create Rev Prod- cost 1 field.

    For example: Data would look like this
    Name overall Detail Net
    a Revenue Rev ser 10
    b Revenue Rev Prod 10
    a cost cost 1 5
    b cost cost 3 3
    e G&A G&A 5
    f G&A G&A 5
    g ETC ETC 1


    Once pivoted:


    Sum of Net Column Labels
    Revenue cost ETC G&A
    Row Labels Rev Prod Rev ser cost 1 cost 3 ETC G&A
    a 10 5
    b 10 3
    e 5
    f 5
    g 1
    Grand Total 10 10 5 3 1 10

  2. #2
    Board Regular alansidman's Avatar
    Join Date
    Feb 2007
    Location
    Steamboat Springs
    Posts
    4,944
    Post Thanks / Like
    Mentioned
    7 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Adding Calculated Field with multiple Columns

    v A B C D E F G H I J K L M N
    1 Name overall Detail Net
    2 a Revenue Rev ser 10 Sum of Net Detail
    3 b Revenue Rev Prod 10 Name overall cost 1 cost 3 ETC G&A Rev Prod Rev ser
    4 a cost cost 1 5 a
    5 b cost cost 3 3 Revenue 10
    6 e G&A G&A 5 cost 5
    7 f G&A G&A 5 b
    8 g ETC ETC 1 Revenue 10
    9 cost 3
    10 e
    11 G&A 5
    12 f
    13 G&A 5
    14 g
    15 ETC 1
    16

    Name and Overall in rows
    Detail in Columns
    Net in Valuses (sum)
    Let me know if that works for you
    Alan

    Am Yisrael Chai

    Win 10--Office 2019
    When Posting Code, please use code tags.
    How to insert Mcode to Power Query https://excel.solutions/2017/11/powe...te-code-video/


Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •