Results 1 to 4 of 4

Use a Pivot table to work out average order value of invoices

Threaded View

Melissa_8 Use a Pivot table to work out... 05-17-2024, 09:11 AM
AliGW Re: Use a Pivot table to work... 05-17-2024, 09:20 AM
Melissa_8 Re: Use a Pivot table to work... 05-17-2024, 09:26 AM
AliGW Re: Use a Pivot table to work... 05-17-2024, 09:28 AM
  1. #1
    Registered User
    Join Date
    05-17-2024
    Location
    Belfast
    MS-Off Ver
    Microsoft 365
    Posts
    2

    Use a Pivot table to work out average order value of invoices

    I have sales invoice/credit note data and I want to find out the average order value for any given month. My report has multiple lines per invoice, as some invoices may have more than one product. I have tried to work out the value using a pivot table but the results are skewed due to the count of the multiple lines on certain invoices.

    I'd be glad of any help on what fields or functions to choose in the pivot table as I can't seem to get the answer I'm looking for.

    Thanks!
    Attached Files Attached Files
    Last edited by Melissa_8; 05-17-2024 at 09:27 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 10
    Last Post: 11-09-2021, 04:21 AM
  2. How to order columns of Pivot table in correct month order
    By Cordelia123 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 04-23-2021, 08:29 AM
  3. Want Pivot table's average to show average by number of month.
    By jp16 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 07-16-2019, 06:07 AM
  4. Filter Pivot table by each customer and auto email invoices unpaid
    By whatsup in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-04-2019, 09:21 PM
  5. Replies: 4
    Last Post: 09-26-2017, 12:41 PM
  6. Pivot table for past due invoices by Customer
    By kpierce in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-24-2015, 01:31 PM
  7. Open Word Work Order Template with excel generated work order #
    By Tivka in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-26-2012, 02:24 PM

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