|
|
Browse by Tags
- 2003
- 2007
- Access
- Add
- Analysys Services
- BI Publisher RTF
- CSharp
- Excel
- Excel 2007
- export
- formula
- Formula on Pivot Table subtotal only
- grouping dates
- MDX
- Microsoft
- Office Excel
- Oracle Applications
- row
- SSAS
- Unable to get the amount column value in Pivot Table Preview
-
Formula on Pivot Table subtotal only
I have the attached pivot table and I would like to calculate column e - column f just on the total rows. How can I do this. thank you in advance for your expert advice. :) -
Unable to get the amount column value in Pivot Table Preview
Hello All, I have the XML data and while creating Pivot table for cross tab report RTF. I have the year coulumn which is dynamic. Under this the amount is showing as zero 0. But the data is available in XML file. Please let me know if missing something. thanks. -
Pivot Table control in C-Sharp
Is it possible to use excel's pivot tables in a csharp application? I have seen a few potential solutions to this, such as grid controls that look and behave in a similar way to pivot tables or inserting an excel object and creating the pivot table there, but this are not really neat solutions. Is... -
Pivot Table add another Row by using Formula in Pivot Table
Looking to add another row int he pivot table as shown in the picture below. Thanks, JP -
Excel 2007 Pivot Table Dimension
My company uses pivot table in Excel connected to our various Analysis Service Databases. I have a large dimension that I often use on the rows of the pivot table, however whenever i go to filter it the small box does not populate and ultimately excel freezes. Is it just a known bug with excel that it's... -
Pivot table question
Dear All, Suppose I have two temporary tables in SQL with common columns like F1, F2 and F3 and different values: Table A F1 F2 F3 1 2 3 Table B F1 F2 F3 4 5 6 I need to make a third table in following format: Table C CF1 CF2 CF3 F1 1 4 F2 2 5 F3 3 6 This third table is having three fields with first... -
Grouping dates by month in pivot table
I have an Access database and have extracted the result of a query into Excel 2007 for analysis. For some reason Excel won't let me group the data in the date field by month using the grouping option. This works with new data created in Excel but not the Access extract. The data in the field is in... -
Problem: Access pivot table to excel
I am running a few pivot tables in Access, and I was wondering if there is a vba code to allow these reports to be pushed into an excel sheet? I know there's a way to create a new file, and have it exported some what through a button located at top, but i'm looking to transfer exactly what the... -
Problem: Export Pivot Table from Excel 2003 to SQL Server 2005
I have a Pivot Table on Excel 2003 workbook which connects to Microsoft OLAP Services 2000 cube and retrieve the required data. I would like to exported the result of the filtered cube and store it in SQL Server 2005 table. How can I achieve that in an automated way? Not by copying the pivot table and...
Page 1 of 1 (9 items)