+ Reply to Thread
Results 1 to 3 of 3

Can a calculated field do this?

  1. #1
    Registered User
    Join Date
    06-17-2020
    Location
    London, England
    MS-Off Ver
    Pro 2016
    Posts
    55

    Can a calculated field do this?

    Hi,

    Inside the attached file are 3 tabs, in the tab marketing it is the amalagmation of all marketing budgets, in tab magazines is the amalagmation of all magazine budgets.

    In the overview tab you can see the red colour pivot tables I've added rows or columns to give me a running total of my budget. Is there a way to do this in calculated fields?
    I feel like I'd need to add ablank column but can't see how to do this? Am I just going about this the wrong way?

    Last year each budget had it's own tab on a spreadsheet, it becomes a bit unruly, I thought pivot tables would solve this but it's proving a bit more tricky.

    Thanks very much.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,424

    Re: Can a calculated field do this?

    Just something to think about, it may be tidier to add the 2021 budget as a line item on each sheet and then refresh the pivot tables to include.
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  3. #3
    Registered User
    Join Date
    06-17-2020
    Location
    London, England
    MS-Off Ver
    Pro 2016
    Posts
    55

    Re: Can a calculated field do this?

    Thanks, It does look tidier but still not doing what I really want. I'll play around some more there might be an answer as it would improve data entry speed if I had fewer tables.

    Thanks for your help.

+ 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. Creating calculated field and calculated item into a pivot table
    By dvpe in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 12-12-2019, 12:15 PM
  2. Replies: 0
    Last Post: 08-15-2016, 02:07 PM
  3. difference between calculated field and calculated column in PowerpIvot
    By stephme55 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-14-2016, 06:05 PM
  4. Replies: 0
    Last Post: 10-24-2013, 10:59 AM
  5. Replies: 0
    Last Post: 06-26-2012, 09:06 PM
  6. Replies: 2
    Last Post: 03-06-2009, 11:49 AM
  7. Replies: 3
    Last Post: 06-06-2006, 12:10 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