subtotals

  1. J

    Subtotal filtered page items

    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).
  2. S

    Can't get subtotals/grand totals to show on rows.

    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...
  3. N

    Subtotal for Calculated Column in Power Pivot Table

    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...
  4. M

    create a dynamic copy of a table on another sheet in the same book?

    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...
  5. M

    Faster Way to Subtotal with VBA?

    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...
  6. R

    Subtotal while condition

    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...
  7. M

    Macro Loop Help!! - Code to Insert Totals into Each Sheet within Workbook - Excel 2013

    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...
  8. F

    SubTotal for treestructure (vba)

    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...
  9. M

    buy & sales data

    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...
  10. E

    Subtotals in Pivot Charts?

    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...
  11. F

    Last Row from different column

    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...
  12. C

    getting Subtotal method of Range class failed error

    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...
  13. L

    Summing Subtotals

    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
  14. M

    VBA custom sort by category total

    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...
  15. A

    Displaying subtotals for only one category in pivot table

    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...
  16. C

    Calculation based upon subtotal in group

    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...
  17. E

    Multi Dimensional Subtotals for Grand Totals in Pivot Table

    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...
  18. J

    Subtotals

    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 ;-)
  19. A

    Subtotal or VLOOKUP?

    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...
  20. T

    Copying Rows based on Cell Values and then adding subtotals

    Hello, I am fairly new to vba. Before I decided to post this question, I did some research and found a similar solution, but was unable to successfully implement the code...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top