-
I have a pivot table with abour 20,000 rowa. The field I need to use in the page filter has about 1300 possible values in random order. When I attempt to use the filter I notice isentical values in the drop down list. Why? and If I select any occurance of will the apply to all 20k records?
-
Hello, I have created a pivot chart that has the ROM for several campaigns and their attributes (creative, offer, location, etc..). The report filter I have set can filter on a date period or campaign type (online, print...). What I'd like to do it to create a series of pie charts to show the ROM...
-
Hi I am trying to extract some data from a long list of gps values from which i want to extract a sum of minutes per week at particular locations. I would like this to be able to be done with a single click/automatically if possible..or at least very simply, as i have to pass the spreadsheet out for...
-
Hi, I'm trying to find net revenue in a pivot table by using the fomula "revenue - (revenue x tax)". I thought it would be simple, but I'm running into problems when the line items get totalled up. When the total is generated, it sums the everything from the revenue and sums all the...
-
I have an Excel Spreadsheet with a cover-page of sorts that provides an overview of the entire year in Trouble-Ticket numbers, Column A – for example has the Category Type – and the next column is January with the number of events for that category type… (See attachment for example...
-
At the Uk Excel User Conference I spoke to Roger Govier and he didn't know the answers to a couple of questions about pivotcaches. He promised to look in to them if I posted them on the forum and maybe somebody else knowes the answers or can comment on these issues. When I create pivotcaches in code...
-
I would like to NOT select any page filters in a pivot table. Currently I can select "All" or a member of the filter. The reason for this is that the pivot table is being published to Sharepoint using Excel web services. In Sharepoint, a pivot table appears to operate slightly differently,...
-
Lets envisage this as a pivot table data, I want to have Grouping of the values for "Sat" to be shown as (3+3+3) nothing but 9 Sat 3 Sat Ate 3 Sat 3 Mat 4 Ate 7 Ate Apple 3 Ate Banana 2
-
I am looking to limit the number of selections available on my filter. Due to the data and cube design, I have had to make a dimension in SSAS (SQL Server Analysis Services) that includes every possible date (ag. 20091231). In the pivot table, I would like it to just display the current Fiscal Year....
-
I have created a pivot tabke with yearly sums, I would like to also show in the same table the same data as a percent of the column and as a percent of the row. I know how to change the way the data is viewed using the Pivottable Field dialog box options and changing the way the data is shown, but how...