I have two tables; Leads, Territories and Referrers. Lead has columns: ID, Name, TerritoryId Referrers has: ID, LeadId, Name Territory has: ID and Name A lead always relates to a territory and a lead can optionally relate to a Referrer. Leads and Referrer records are regularly inserted (Referrers less frequently). I want to outpu...
in Excel , in my pivot tables when i drop down the row fields, value filter option is disabled any idea why ? ...
I need to make a pivot table on my Crystal Reports. Right now i'm using an OCDB connection...but while i know you can create a pivot table in CR, i'm not 100% sure how to do it. Anybody here know an easy step-by-step way to do this? ...
i have an excel data . the 3rd collumn contains phone numbers . i have to delete rows whose phone numbers have less than 10 digits . as the data is very large and not even one mistake is acceptable. i want to use pivot tables or automation script. pivot tables is better because the number of digits is variable and the collumn number is ...
I have a workbook connected to an external OLAP cube. Previously, when I connected to the external data source and then refreshed all, every pivot table would refresh and show the new data. Now, if I connect to the data source and refresh the pivots, the pivots do not update with new data. The only way I can get it to update is if I m...
Hi all, Background: We need to consolidate sales data across the country to do analysis Our Internet connection/IT expertise/IT investment is not quite strong, therefore full BI solution is out of question I tried several SaaS BI solution (GoodData, ZohoReports) and while they're good, they seem not to fully support what we need We'r...
I have an Excel spreadsheet which has a pivot table on it. The data itself is quite simple, Number of Units and a Discount (percentage from 0 to 100), pivoted on date across the top and customer down the left hand side. Those numbers are straight from a SQL view, so the pivot table source is just: SELECT * FROM UnitDiscountView All wa...
The situation is the following: In a database I have a table that stores the number of occurrencies an error occurred. Say ErrorId Timestamp N Err1 t1 2 Err2 t2 7 I query this data, and must use the cross-table of crystal report to show the data. Three (3) error codes must be shown: Err1, Err2 and Err3, in t...
I have a row of data as follows: header1 header2 header3 header4 header5 row key datavalue1 datavalue2 datavalue3 datavalue4 datavalue5.... so basically, I have a denormalized data set where the datavalues may or may not be empty on a row-by-row basis. I need to normalize them. ie 1234567...
I am having a really difficult time getting the result I need out of the following query. SELECT SUM(HEALTH_MTTR) AS MTTR, SUM(HEALTH_OTR) AS OTR, SUM(HEALTH_REPEAT) AS REPEAT, SUM(HEALTH_CHRONIC) AS CHRONIC, SUM(HEALTH_TOTAL) AS TOTAL, (CAST(CAST(YEAR([DATE_RESOLVED_FOR_CLOSURE]) AS VARCHAR(4)) + '-' + Right('00' + CAST(MONTH([DATE_RES...
I have about 12 pivot charts and I need help to creat a VB code that will delete only the zero values(Data values) on all the Pivot chart. These are Stacked charts for 3 metrics. eg : Ontime, late and not notified. I need only the values which are not "0" to reflect on the pivot charts.Please help. ...
Hello all. I am trying to get a grip on the pivot query syntax. I have about 20 fields worth of aggregate data all associated with 1 field, which is the category for those 20 fields (by fields I mean columns). It looks like this Category1 column1 column2 column3 Category2 column1 column2 column3 and so on.....
i am using asp.net mvc so the solution can be either server side or client side (jquery, etc). i can't seem to find any good tools that can mimic excel pivot tables (allow user to get the pivot table experience that they get with excel pivot tables) on the web with good performance. ...
I have a employee table which contains employee information and a Contact details table which contains the phone numbers of the employees. the employees have more than 2 phone numbers. now, to display the employee information, i have a datagrid. what i want to do is display the first 2 numbers along with the employee information in the ...
Is there a way to make values in a cell that are comma delimited (ex. cat, dog, fish) became separate labels in a pivot table instead of getting labels like 'cat, dog', 'fish, cat', 'cat, dog, fish' which represents the exact value in the cells. The only real option I can think of would be to make an extra rows with the same data for ea...
I've got a list of transaction dates and the user id of the person who made the transaction on that date (just 1 Tx/day allowed). For example: I'd like to create a matrix which shows, as of each date, the number of users who have made 1 transaction, 2-10 transactions, 10-20 transactions, etc. For example (note, the below data doesn'...
I'm looking for a SQLAlchemy only solution for converting a dict received from a form submission into a series of rows in the database, one for each field submitted. This is to handle preferences and settings that vary widely across applications. But, it's very likely applicable to creating pivot table like functionality. I've seen th...
I've created a cube in SSAS 2008, and have it deployed to my local server. I can connect to the cube via Excel 2007, and the pivot table and pivot chart work perfectly. When I try to drillthrough on a cell to see the detail rows, I get the following error: "The query did not run, or the database table could not be opened. Check the dat...
Scenario I have a database made up of 4 columns and 6 million rows. I want to be able to be able to use Excel to query this data in the same way in which I can query it using the Sql Server Management Studio. I've had a google around and read a few articles but in all honesty I dont really know enough about the implementation to really...
I would like to extract some data from three tables in a SQL Server 2005 database. While this can surely be done in code, it seems like this could be done reasonably well in SQL (bonus points for LINQ!). Basically, I would like to know for each month how many calls and meetings each employee has held with each of our clients. Somethin...