subtotals

Hello, I am trying to figure out if there's a way to use VBA to find subtotals based on two criteria. The data is already sorted by these two criteria (line number and department number) and I'd like to be able to draw a bottom border across the cells and put the subtotal on the last cell that...

Anyone have any idea what this is and how to use it? I've tried having filtered items in a pivot table with subtotals on and it's still grayed out (xlsx file).

I have a pivot table that is showing grand totals at the bottom but I need it to show individual totals at the end of the rows. I have tried the Turn On for Rows and Columns several times and nothing is happening. If I turn off the Columns it takes away the grand totals at the bottom and will...

I want to sum the results of a calculated column in a PowerPivot calculation but the calculation is actually being performed on the subtotals also - is there a way I can change this? The calculation is TargetMet=IF([Sum of Actual Income]>=[Sum of Planned Income],1,0) I would like the subtotals...

I have a large table of data which changes size (increase/decrease rows) every day. I want to put a copy of this table which reflects changes in the original table on another sheet so I can add more formulas, subtotals and filters etc. Is there a way to do this? I tried a pivot table but it...

Hey everyone, I have a macro that contains a series of subtotaling based on criteria, and it seems to add the most time to the entire macro to execute. It is a decent set of data, 500-700 rows at a time, and subtotaling several things in succession. Is there a command to do it faster than the...

Dear friends, Is there any formula or VBA Code that allows me to subtotal a group of cells based on their cell background color but as enlisted in the "Desired formula" column as follows: D4 Subtotals D5:D8 D5 Subtotals D6 D7 Subtotals D8 D6 And D8 Are data captured manually Thanks a lot i...

Hello all, I am working on a piece of code that currently works fine if you trigger the code sheet by sheet manually, but when I add a loop code it keeps entering the subtotals in the same sheet over and over again? Any help is appreciated! Sub forEachWs2() Dim ws As Worksheet...

Hi, Im trying to implement SubTotal for my tree structure. I have validation list with values: H1, H2, H3, H4. Example: when user select H2, SubTotal should sum each value from H2 to H4 level. When select H3, SubTotal should sum each value from H3 to H4 level. Please see below example...

Have a list or trades, buy and sell data. Want to subtract purchase amount from sales amount. How can I change purchase to negative so that I can use subtotal to sort transactions for different products? Sample product Amount Gain/loss (Other fields like date and quantity not to...

I know you can add subtotals in pivot tables, but can you add subtotals in pivot charts? Below is a small sample data. I would like a subtotal in chart for the Report Year. Thank you. Report filters: None Legend Fields (Series): Type Axis Fields (Categories): Report Year Values: Sum of Values...

I would like to copy the content from cells above blank cells to subtotal rows. (In this example, columns A, C and D). The last row should be determined by Column B, which contains the filter for the subtotals. There is something wrong with my syntax, and I can't figure it out. My code is...

My macro for sheets VP and VP2 that subtotals results of a query was working fine. The workbook has 2 sheet, VP and VP2 which are subtotaled. I needed to add a copy function to sheet VP to copy the subtotal lines to the top of the sheet (beginning at row 5). This may or may not be working...

Hi, I have basic knowledge of PowerPivot but I was wondering if there is a way to total the subtotals in a PowerPivot table? Maybe someone has an example? I good at reserve engineering. Thanks, Luke

Tried my best to figure out the best way to do this and came up short. My data looks something like this: <tbody> Category 1 Category 2 Account Desc FY13 FY14 FY15 Revenue Product 1 Sales 100 110 115 Revenue Product 3 Sales 100 150 300 Cost of Revenue Product 1 COGS 20 30 30 Cost of...

Hello all, First time posting. I searched the recent postings, but didn't find what I was looking for. I have a very large data-set (25,000 + rows) so I want to display only the information that is relevant. I have the pivot table set up as follows: Rows: Salesman Customer Account Number...

This should be very simple, but I am obviously missing something here - PowerPivot 2013. In this example I am trying to get revenue per employee (highlighted in yellow) In order to do that I need the numerator to appear in every row (red arrow in subtest) I thought this would do the trick...

For Sales Analysis, I use large pivot tables, based on transactional data. I want to be able to analyze everything in three dimensions: 1. Product: Product Group, Subgroup, Product 2. Geographical: Global, Continents, Countries 3. Time: Year, Quarter, Month I currently use the following set up...

Hi, I have a filtered table that I was hoping have running subtotals on. I'd like the subtotal to count the number of extries in a filtered table that are greater than 0. Is this possible? I couldn't find anything similar in the SUBTOTAL() code. Thanks, guys ;-)

So this is what my data looks like 2014 Usage 2015 Usage 20000007 20 11 20000007 -1 0 20000007 1 0 20000007 0 20000007 Total but for a spreadsheet that has about 10,000 items. Is there a formula that...