I'm currently working on a Java application that uses a template excel file that contains a pivot table. The template file also has a data sheet that seeds the pivot table. This data sheet is dynamically loaded in the java application through the Apache POI api. When I open the excel file I must refresh the Pivot table manually to ge...
I've got a pivot chart which spans several years on the X axis, with data for each day. The problem is that there's a label on the X axis for each day, so they are too cluttered to be readable. I'd like to show just the months as labels instead of the days, and still see data points per day, but here's what I found so far: Doing this i...
I am required to generate a Pivot table in MS Excel(not in Open Office) dynamically as per the User's query. I am programing in java and MySql(DB),so cant use the windows or MS object directly that's why wana to use VbScript . This vbscript will contain data as well as orentation on the columns in Pivot fieldList .But can any body tell m...
Is there a pivot table component for Delphi that is opensource or freeware? ...
Excel 2007 with Data in SQL 2008 View. Trying to create a PivotTable from an external datasource (SQL 2008 - View). I would like to create a filter for a date range, since the view contains a lot of records. The problem is I can't figure out how to specify a filter for my view so the filtering takes place in SQL. Ideally user would be ...
I've got a large set of data in Excel 2007, but the rows should have been columns, and vice-versa. Is there a simply way to "pivot" this spreadsheet, rearranging all cells so that the rows become the columns? ...
I received an Excel file that references some data from a MDB file. When I open the file, I am only able to see summary based on dropdowns and pivot tables. The data from the MDB file appears to have been embedded in to the XLS file itself. If I look at the file in Notepad++ I can see the information I'm looking for (albeit mixed in wi...
Hi, I tried to search posts, but I only found solutions for SQL Server/Access. I need a solution to MYSQL (5.X). I have a table with 3 columns: hostid, itemname, itemvalue. If I do a select, it will return 1 A 10 1 B 3 2 A 9 2 C 40 How do I query the database to return something like A B C 1 10 3 2 9 40...
I'm writing a plug-in for a program that ultimately outputs some data into a few tables. The users need to be able to analyze this data through various reports. But right now the work flow is to export the tables from my plug-in to another program like excel or access to manipulate the data and generate reports. The users aren't the most...
I have written several Subs to show/hide fields in a PivotTable. Now I am trying to do the same with a calculated field, but I get an error when hiding it. I took my code from the recorder and the recorder's code also halts on the last line. I googled the error message, without serious result. Sub PrRemove() 'remove PR Dim pt As...
In Excel 2007, I have a single dataset in the form of an Excel Table from which I want to make multiple pivot tables and pivot charts. I would like to be able to synchronize the 'report filter' field across all of the pivot tables and charts simultaneously, so that by filtering, (for example) the US_Region field to 'Pacific Northwest' on...
I have a customer table: id name 1 customer1 2 customer2 3 customer3 and a transaction table: id customer amount type 1 1 10 type1 2 1 15 type1 3 1 15 type2 4 2 60 type2 5 3 23 type1 What I want my query to return is the follo...
In Excel 2003, I have a macro that accidentally tried selecting a page field item (New York) that didn't exist. This renamed the currently selected page field (Alabama) to the value I tried to select (New York). I now have 3 or 4 values that are now wrong. Is there a way to refresh these pivot table values to the correct values without ...
Hi, is there a way I can sort pivot-table field list (measure names, attributes) by it's caption instead of default by name defined in the cube? Eventually, can I recreate the field list by hand? ...
Excel Pivot Tables can display a grand total row that, by default, sum each column's data. I would like to display multiple grand total rows that display each column's count, average, standard deviation, and standard error. Does anyone know how to do this? ...
I am new to working with XSLT and am trying to create a pivot table using the Muenchian Method (since it appear that IE still doesn't support XSLT 2.0 I think I'm stuck with this). I am able to get the desired grouping however I am trying to get the sum of an attribute for each group. To do the sum of the attribute can I use the aggreg...
I am trying to display a tabular set of data in a databound control, but I need to pivot the table such that the individual records are table columns rather than table rows. The end result is a table with a fixed number of columns and a variable number of rows each displaying single field for all of the records like this. Due to the fact...
I have a sheet (let's go with wines as an example) that lists every bottle of wine in my cellar, when I bought it, how much I paid etc. There's a column that describes the wine in comma-separated tags such as "Fruity, White". I've created a pivot table from that data, with the description as a filter column. However I can't filter it b...
I have a query which I use to grab specific dates and a price for the date, but now I'd like to use something similar to grab the avg prices for particular days of the week. Here's my current query which works for specific dates to pull from a table called availables: SELECT rooms.name, rooms.roomtype, rooms.id, max(availables.updated_...
I am working on a pivot table query. The schema is as follows Sno, Name, District The same name may appear in many districts eg take the sample data for example 1 Mike CA 2 Mike CA 3 Proctor JB 4 Luke MN 5 Luke MN 6 Mike CA 7 Mike LP 8 Proctor MN 9 Proctor JB 10 Proctor MN 11 Luke MN As you see i have a set of 4 distinct districts (...