r/excel•
Da2Shae

Excel Pivot table nesting?

Removed - Rule 1

[removed]

Posted Aug 26, 2021, 7:48 PM UTC · locked

34
CHUD-HUNTER519•

You would need to duplicate the row for each "category", changing the Check Amount and Description columns.

When you create your basic pivot you can omit the Description field, drag check amount to values, and it will give you the total price per invoice. When you create your more detailed pivots and include the Description field it will break the invoice into multiple lines - or allow you to filter by desired description.

2
[deleted]•

[removed]

1
Requin2018•

This isn't a fully fleshed out idea, but what if you did something like this where you change Check Amount to Total Check Amount and keep those values the same, but then add a Sub-Amount column with the itemized amounts and a Sub-Description to name those amounts? For Invoices that don't need to be itemized, you could just have the Sub-Amount and Sub-Description match the Total Check Amount and Description. When you create a pivot table from this data, you can use the Sub-Amount for the values and they will add up to the Total Check Amount.

+ABCDEFGHI
1PropertyInvoice DateGL CodeInvoice NumberCheck #Total Check amountDescriptionSub-AmountSub-Description
2A12/2/20204430-00-000120183331$415Plumbing Repairs$415Plumbing Repairs
3A12/2/20204430-01-000120093350$50Drywall repair$50Drywall repair
4B3/28/20204800-00-00011482105005$2,000Full Turnover of property$1,000Plumbing Repairs
5B3/28/20204800-00-00011482105005$2,000Full Turnover of property$200Floor Replacement
6B3/28/20204800-00-00011482105005$2,000Full Turnover of property$300Drywall Repair
7B3/28/20204800-00-00011482105005$2,000Full Turnover of property$500Cleaning Fees
8C1/1/20214430-01-00012056105$100Cleaning fees$100Cleaning fees

^Table ^formatting ^brought ^to ^you ^by ^ExcelToReddit

1
Clippy_Office_AsstMOD•

This post has been removed due to Rule 1 - Poor Post Title.

Please post with a title that clearly describes the issue.

The title of your post should be a clear summary of your issue. It should not be your supposed solution, or just a function mention, or a vague how to. A good title is generally summed up in a sentence in your question.

Here's a long example and a short example of good posts.

Rules are enforced to promote high quality posts for the community and to ensure questions can be easily navigated and referenced for future use. See the Posting Guidelines for more details, and tips on how to make great posts.

1