Do you know of any good doc on Excel PivotTables object model ? I have read "Excel 2007 Programmers reference", googled a bit, and found small bits here and there, but nothing global, coherent and complete. Preferably for version < 2007, so I keep upwards compatibility when developing. Thanks ! ...
This question is very much like my previous question, but a bit more complicated. Rob van Wijk's answer worked perfectly for my other question, and I've been using that as a starting point. My problem now is that I am pivoting dates for different fields. Whereas before I cared about getting all open_in and open_out values for a given ...
I have a Pivot Table which I have entered a date field into the Page Fields area to filter the data in the page. However, I only have the option to select individual dates. I want to use a date range. How can I do this? Or Can I do this? ...
Let's say I have a table like this: Task Type Variable Hours Duration One A X 10 5 One A Y 40 15 One B X 100 29 Two A X 5 2 Two B X 15 9 Two A Y 60 17 Three A Y 18 5 W...
Dear All, Any idea about how to embed/insert pivotTable/pivotChart in a userForm? *code sample will be great to share. 1000,000 thanks in advance ...
hi all, I have the following kind of data table in excel: Id | Item | SubItem The SubItem column can contain values ranging from 'A' to 'F' The Item column contains two items: 'Cat' and 'Dog' There is a dependency between Item and SubItem. For our example, let's assume that all rows where Item = 'Dog' can only have 'A','B','C' as Sub...
Hi, Can anybody recommend good front end SQL server development pivot table components? Other than the Microsoft Office offers. Something intuitive and web based. Thanks for your time Paul ...
Hi, I have an Excel 2010 pivot table that has categories and a count measure as the data. Those categories then have a date dimension nested underneath, filtered to show only the last two months. When I sort the categories, I am sorting them by the total of the count measure across both June and July, in descending order. Can anyone ...
I have a database to access via JDBC which returns around 200k of records I have to consolidate data table style for further processing. I could if that leads to good performance send a few SELECT (Count(...) ...) statements upfront. What is a good algorithm in Java to compute such a pivot table? ...
I am attempting to make some reports in Excel using a pivot table of a Sql server view. One of the customer requirements is to be able to filter the reports based on a date range they select, which seems reasonable. The end user process needs to be fairly simple, so my preference is to have a cell for begin date and one for end date and ...
I want to color the cells of a pivot table in a way that it highlights the highest values in the row. The table I have is something like this: ________|_Field1_|_Field2_| ________|_X_______________|_X_Total_|_Y________________________|_Y_Total_| _Field3_|____A___|____B___| |____A___|____C___|____D___| | ____1___|____3___...
Hi, I have a pivot table created from 3 fields where (for example): field1 values are: "1", "3", "5" field2 values are: "A", "B", "C" field3 values are: "X", "Y", "Z" So given a pivot table PT1 I want to reference a cell within the table in a similar way to PT1["1"]["B"]["Y"] and get a Range item returned. Is this possible? Thanks. ED...
I'm just starting to learn Entity Framework 4, and am a bit confused about how pivot tables enter the mix. Case in point: I'm migrating a video game review site from PHP 5/Kohana framework to ASP.NET MVC 2. I have a few pivot tables to map the many-to-many relationships I have. Example: Video games can be available for several platfo...
I hv rows of data:- TAG SKU SIZE GRADE LOCATION A001 123 12 A X1 A002 789 13 B X3 A003 456 15 C X5 I need to convert it into:- A001 123 SIZE 12 A001 123 GRADE A A001 123 LOCATION X1 A002 789 SIZE 13 A002 789 GRADE B A002 789 LOCATION X3 A003 456 SIZE 15 A003 ...
I have a table that stores "comments" on "parent" items in various "languages", with the "date" (dateTime) it was added. Example data: DROP TABLE IF EXISTS comments; CREATE TABLE comments(parentid INT, language char(2), body TEXT, date DATETIME); INSERT INTO comments VALUES (1, 'en', 'english comment 1-1', '2010-09-01 11:00:00'), (1, 'e...
i have some mysql script for pivot table and then counting some data inside that: SELECT A.Line, week1.1stweek, week2.2ndweek, IFNULL(week1.1stweek,0) + IFNULL(week2.2ndweek,0) AS TOTAL FROM inspection_report AS A LEFT JOIN( SELECT Line, (SUM(S) + SUM(A) + SUM(B)*0.4 + SUM(C)*0.1)/COUNT(Serial_number) AS 1stweek...
lets say my table like: Date Status 2010-01-02 2010-01-03 accept 2010-01-03 accept 2010-01-03 reject 2010-01-03 2010-01-04 reject i want if value null, it means accept. Beside that i want show the result like: Date Accept Reject 201...
Are there any open source pivot tables with drag&drop support or what is the fastest method to implement it? Which JS library to use? I wanted JQuery, will this be the right solution? ...
Are there any JQuery plugins that create pivot tables? I searched and searched but didn't find anything on the net. Anyone know of any good ways to create pivot tables on the clientside? ...
Hello, Using C# and OWC 11.0, I need to create an excel output with all Raw Data in one sheet. Using that data as the connection string, i need to create pivot tables in another worksheet. This excel sheet will be downloaded by the end user so they can change parameters in pivot table and get the report they need. Whenever the raw data ...