1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Pivot Table help to calculate # To Sell, # Sold and # Unsold

Discussion in 'Business Applications' started by FernJones, May 29, 2019.

Thread Status:
Not open for further replies.
  1. FernJones

    FernJones Thread Starter

    Joined:
    May 30, 2011
    Messages:
    26
    Hi,

    I need some help with a Pivot Table please, so I can avoid manual calculations.

    I have attached a file which shows my Data, my current Pivot Table and the Pivot Table I'd like to achieve. It's basically # of items in our inventory, # sold, % sold, # unsold and % sold.

    I have tried to utilize everything I've previously learned on this website, but I am stuck.

    My data shows only items that were sold. If nothing is sold on a specific date, my data file doesn't contain anything for that date, so I've manually added those in with Date Holders.

    Any help is much appreciated, thank you so much, in advance.
    My best,
    Fern
     

    Attached Files:

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1227843

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice