+ Reply to Thread
Results 1 to 1 of 1

Power Pivot Calculations and Filters

  1. #1
    Registered User
    Join Date
    09-27-2019
    Location
    Dublin
    MS-Off Ver
    Office 365 Pro Plus
    Posts
    11

    Power Pivot Calculations and Filters

    "#1) In column H 4:16, the total invoice value is 31,269.05, however on each line of data the total invoice value is indicated. I have used Average of in this column to come to the correct total (H16).

    I need to put in a calculated field that will determine the difference the between Subtotal rows only for Sum of Rebill amount and Sum of Invoice Amount to Avoid confusion as the individual data always states the total Invoice amount (H4:15).

    EG the calculation result should state for Row 16 (31,269.05-27,907.05) =3,362; Row 18 = -2000 and Row 21 = 0."


    "#2) I need to create a column, that if the subtotal of rebill amount and Invoice amount is equal, it can be filtered away (I only need to inspect when subtotals do not equal).
    Additionally, (e.g. the top set of data), this 3,362 variance may be determined to be a correct variance. Is there a way where I could manually 'tick' a cell e.g. in column I that I could then filter on.

    The end goal is I would like to double click the Grand total value (or similar) after having filtered out the two above (values net match, or variances are approved to be accurate) to get all original data lines that have not been fully matched off yet, in this instance it would be row 14 in the table.
    This would then be carried forward as the start for the next reconciliation process."
    Attached Files Attached Files

+ 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. Trying to make simple calculations in Power Pivot
    By juanzo007 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-10-2021, 11:38 PM
  2. [SOLVED] 2 fields checker- Request for alternative option in Power Query or Power Pivot
    By Shareez Saleem in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-15-2020, 08:36 AM
  3. Replies: 3
    Last Post: 08-10-2020, 11:38 AM
  4. Replies: 12
    Last Post: 09-27-2019, 01:45 AM
  5. Sub-Forum for Excel Power Tools (Power Query, Power Pivot & Power BI)
    By chullan88 in forum Suggestions for Improvement
    Replies: 10
    Last Post: 06-28-2018, 02:25 PM
  6. Duplicate filters in Power Query
    By leukep in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-20-2017, 05:06 AM
  7. Pivot Filters to change simulataneously with other pivot filters
    By ScottBeatty in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 07-02-2014, 10:48 AM

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