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

</SPAN></SPAN></SPAN></SPAN><o:p>Hello all! =D I'm trying to create a vba code to automaticaly put all the fields and formats to my pivot tables to speed up my analysis. I'm having problems with the final part where I want to disable the subtotals... The full version of the code is at the end of...

Hi I am fairly new to excel and I am having trouble trying to get a sub total function to work for me. I need the subtotal to for a list of about 20 columns in one line with a varying amount of rows. So the subtotal must stop when there is a blank at the top. I can get the macro to find the...

I believe this is not possible (as i am getting an error saying so) but does anyone have a workaround for getting monthly subtotals on a pivot table where there are calculated items? i've tried two ways: - highlighted date in the pivot and clicking field settings and then custom and then sum. i...

I'm working on a pivot table where I want to move certain expenses from a department in one category to a department in another category. My pivot table is set-up with the "Category" and "Department" fields in Row Labels. My departments sum correctly in "Asset Retirements" based on the...

I often have spreadsheet with many columns on which sub-totals are calculated in 1 or 2 columns. Excel posts xxxTotal in the columns on which the sub-total is based. If you collapse the table to only show the subtotals, the rest of the fields are hidden. I would like to see all the data of the...

Hello - I have designed a spreadsheet that seems to be a little cumbersome to gather data from. In the long and short of it, I'm trying to create a count for how many ads we posted, in which cities, during which quarters. Here is how the data is laid out: <tbody> Location Quarter - Website A...

Excel 2007 user. I have a spreadsheet with over 1000 lines of data, that is spearated into 30 different subtotal groups. I tried to eliminate the subtotal lines and revert back to the original dataset. I started clicking the small box in the upper left corner to select the entire dataset. Then...

Hello all, I have a query about summarizing data across sheets. I have my data in 12 sheets named by the month names and a Summary sheet. I have to summarize the data in the Summary sheet. The columns in all the sheets are Product, Qty for 4 regions, Sales for 4 regions, Commission for 4...

I have a table that includes several columns of data. There is a column with employee names and another column with employee hours for each week the employee worked. Each record represents a week of work and therefore includes the emplyee's name and hours for that week. I want to subtotal the...

Hi I'm trying to calculate the number of rows in a matrix that have a complete row of data. I would noprmally do this using nested if formuals and a count function, but the columns of the matrix are filterable so the count won't work. Is there a combination of functions that will adapt as I...

I am trying to work out a spreadsheet that I am using conditional formatting to highlight every two rows. I have 2 lines for each item and i need them to be grouped together. I can get the formula =mod(row(),4)<2 to do this, but then when i go to add the subtotals for each section it screws up...

I've got circa 20k rows of data I'm analysing - it's activity with our clients over the last few years. I've used the Subtotals function to calculate Sums, Counts and Max values. But I'm stuck on two things. 1 - I want to show the last time we received a payment from a client - to do this I...

I'lll throw this out to you guys... In Excel I am working with pasted output from an Access query that summarizes shipped packages by Service Type, pricing zone and rated weight. Goal is to find the mode weight for each service type. Currently I pivot the results and make the service type...

Hello all, and thank you in advance for any help given. I have 300 - 400 row sheets that I get every week that i need to separate chunks of rows (by dates), insert a blank row, and calculate the subtotal. Below is an example of what the information looks like before it is subtotaled Date...

I have a set of data that I ran Excel's embedded Subtotals function in the Data tab and used the Sum function in column "I" for each change in column "B". I am wanting to do a weighted average of column "L" based on column "I". I found this set of code in the forum that should take of this...

Do pivotFields have a property to let me not do any subtotal at all? For example, I have 'order by date' and 'item' as my rows, with 'amount' and 'deliver by date' as my values. I want to total amount, but totaling the dates doesn't make sense to me. I've been going with 'min of deliver by...

I have a pretty basic pivot table, but it is rather large. This pivot is by order number. What I would like to do is hide all order number rows if the net activity zero's out in the subtotal. Can it be hidden or quickly filtered? The subtotals should only show non 0 rows. So in the example...

Hello, I'm a newbie to VBA and I am having difficulty selecting only the subtotal rows after I've used the subtotal function in excel. I need to highlight the subtotal row a yellow. These subtotal rows are dynamic... Any help would be much appreciated.

Hi Folks I was wondering if there was a way of making a formula dynamic/generic so that it would subtotal any column I want. The limitations would be that Row 1 always contains the header and that the result (subtotal) should be offset by 2 rows in the same column. So basically, if I have data...