grand

Hello and Merry Christmas I have a spreadsheet with about 14,000 rows of text data, much of which still needs a lot of cleansing but I'm sure there must be a number of ways to save time. One of the tasks I need to do is to be able to sort all the entries in one column, theatres, into one of...

Hi<o:p></o:p> I have the following pivot table created from apower pivot table, linked to SQL data base. When I select the Grand Total (68) it does not display the 68 recordsbut instead opens the whole table related to the pivot table source. It wasworking fine before. <o:p></o:p> <tbody>...

Office 365 Business / Office 2016 desktop software I have a pivot chart built from 4 relational tables. I have 5 slicers to manipulate the chart in various ways. I would like to have a "grand total" label displayed on the chart somewhere, that dynamically updates as we slice-n-dice the data...

Hi, I am trying to calculate a weighted average in the Grand Total of a pivot table. I have lots of columns and one column carries volume which I need to use as the weight, so I am trying to show the Weighted average of all the different types of cost of the items grouped together. can somebody...

What determines the order of the columns headings from left to right? In this example it appears to be alphabetical, but is that always the case? Is there any set rule to this? Could have sworn I'd seen an example where this wasn't the case before. Is there a way to change the order using VBA...

Hi is it possible to use the grand total of a measure in another measure calculation. For example , in the table provided I want to multiply my FCST column by the grand total % in my Measure 1 column (22.24%) and the % ALP column ( 12.99%).(Measure 2)...

I have the following data in a Pivot Table in column C: Value 10 20 30 40 50 60 70 80 90 100 Grand Total: 550 I would like to create a dynamic range that references only the last 5 records of the Pivot Table: 60, 70, 80, 90, 100. The formula I'm using is...

I have the following code - (some sensitive information replaced by the word info) which works fine when each subtotal group has several entries, but falls over when there is only one entry. Could someone please help me out. The part of the code where is it specially giving me the 1004 error...

I have the following SUMIFS formula =SUMIFS(B5:B23,A5:A23,({"60-90","120+"})) I would like to increase the range to the last column before where "Grand Total" appears The ageing (Criteria is in Col A) I am trying to sum all the values in Col B to the col before Grand Total (last Col)...

Hi everyone, I have a "Summary" sheet and other sheets namely "Sheet A", "Sheet B", "Sheet C", "Sheet D", "Sheet E", "Sheet F", "Sheet G", "Sheet H", "Sheet I". In those sheets from "Sheet A" to "Sheet I" has the word "Grand Total" at the bottom in column B which varies in location due to...

Hello, I have a pivot table with 3 columns of data and a grand total column as well. I would like to add a calculated field to the right of the grand total column that is doing the calculation 11% * grandtotal my issue is how do i access the already calculated field of the grand total>?