Question about Microsoft Office Excel 2003 for PC

1 Answer

Not able to exclude hidden items from the total

I am taking report from external data source pivot
(from sap bi queries). while excluding the hidden items i am getting error like" This data provider does not support totals that excludes hidden items".

Kindly help me.
Thanks
Vennila

Posted by on

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Scholar:

    An expert who has written 20 answers of more than 400 characters.

    New Friend:

    An expert that has 1 follower.

  • Expert
  • 48 Answers

The solution to your question can probably only be resolved by the developers at SAP modifying how their software functions. Sometimes the answer is not what seems expedient because that could take months or years to have solved. I suggest posing this to them because your error exactly matches what you see as the issue.

Posted on Apr 07, 2009

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

Where can i get installation source of crystal report for visual basic


Probably here:
http://www.sap.com/australia/solution/sme/software/analytics/crystal-reports/index.html

Sep 26, 2014 | Business & Productivity Software

2 Answers

How to automatically import data from tally to excel. Want to display auto imported data in sharepoint.


Import TALLY Data / Export TALLY Data
Tally allows users to Import data from other software's as well as Export data from Tally to other software's. Tally allows users to Import and Export in ASCII, SDF and XML formats. XML is now the most widely used format of exporting data in the world. Any transactions can be exported from Tally and imported in other software after suitably altering the current structures to accept Tally data structure. The reverse is also possible by writing a small TDL program to accept the data from other software's. The data that is to be imported into Tally can be in either XML or DBF format. Easy Tally data transfer or Tally data migration from Tally 4.5 & Tally 5.4 to Tally 6.3 , Tally 7.2 , etc.
ODBC COMPLIANCE ALLOWS OTHER PROGRAMS TO USE DATA FROM TALLY DIRECTLY. E.G. : MS-EXCEL :
ODBC - OPEN DATABASE CONNECTIVITY
Tally is now ODBC compliant. Hence, any program like MS-Excel, Oracle etc that is ODBC compliant can use data from Tally. Here, data connectivity is dynamic i.e. any new updation in Tally is reflected in other ODBC Compliant Software immediately. Now, with ODBC facility the user can extract data out of Tally and design his own report formats in other ODBC compliant software's.
Procedure :
Now, Load Company -> specify period -> minimize Tally -> Open a new Excel file -> select data -> select 'Get External Data' -> select New database query -> choose Data Source
Tally connects to data source and displays Tally Wizard query screen -> select the columns you would want to include in the query.
Once all the columns are selected, the user returns to excel and excel displays all the columns selected
Graphical Analysis of Tally Data
Sometimes, pictures can say better than figures. Tally also provides graphical (Bar graph) analysis of data. The user can do a graphical analysis reports like Sales register, Purchase register, Ledgers, Funds flow, Cash flow, Item registers etc. This helps the user in deeper analysis of data. In Tally, a graphical analysis can also show month wise graphs for the year in comparison with any other period. This will help the management in quickly locating the highs and lean periods in a financial year and hence be better prepared for difficult times.
Web Enabled
Tally ees 6.3 is now Web enabled. This will help the user in reducing his paper work further. Now, report in Tally can be e-mailed directly from Tally. It is not just reports, but even invoices and purchase orders can also be e-mailed directly from Tally. Hence, the user does not have to send printed invoice or purchase orders from Tally.
Procedure :
Select any report (e.g. Balance sheet) -> select Alt+M (E-mail) -> specify all details as required by Tally
Ability to Publish Reports and Documents on the Internet
Now, Tally allows users to upload reports on the web site directly from Tally. So companies that would want to publish reports on the web site can do so directly from Tally. Many companies would also like to publish their price list on their websites along with the product they deal with.
Procedure :
Select any report (Profit and Loss A/C) -> select Upload (Alt + O) -> specify all details as required by Tally.
Direct Internet Access
Tally now offers direct Internet access. A Tally user while working on Tally can directly log on to tally website get details of all the facilities offered by Tally. The user can also download the latest releases of Tally 6.3 as and when available. Tally website also offers a facility of Tally Chat. Any user can now chat with a Tally representative and get any information regarding Tally.
Procedure :
Start Tally -> now, from any screen select Web Browser (Alt+W). Tally now takes you to the Tally Web site.
Print Preview
Any user would ideally like to view format of reports / Invoices / Vouchers before printing the same. Tally now offers a facility of print preview. Now any report can be viewed before printing or before it is mailed. Once Tally shows the preview the user can either opt to print or mail the same.

Apr 15, 2010 | Microsoft Office Excel 2007

2 Answers

Access database was copied now no tables in dropdown list


Your version of Access may require slightly different menus and clicks than mine, but the procedure is straightforward and should be very similar to what you will need to do. Read the whole post first!

Make sure you have permission to modify the database, then go to the form (I assume the drop-down table is in a form) and go to design view.

In design view, click once on the dropdown box you are having a problem with, and a properties screen with several tabs should pop up; click on the data tab, and look at 'data source'. In the list look for 'row source type' to see if the source of your data is a) a table or a query, b) a value list or c) a field list. Most dropdown boxes use either a value list or data from another table or a query (based on a table).

Check the source of data by going down to the next line in the list titled 'Row Source' (this is the list on the data tab that popped up when you clicked on the dropdown box in design view).

If the source is a table/query type you should see some code in the Row Source box like "SELECT....". Without changing anything, click once immediately to the right of the box, and whatever source the rows are coming from should pop up--if a query, for instance, it will pop up the underlying query in design view.

You should be able to troubleshoot the underlying query to see why no data is given in the dropdown box.

Another point where underlying query or table is used: If the table was based on a query that pulls data from the records in the current database, the drop down list will be blank until new records are added so the query has something to list.

And if the source is a 'value list', the values should be included in the row source box below, separated by semicolons. If not you simply need to add them in.

If your source is a field list, go back to whomever copied the database and tell them you need help with the copy they gave you...

Sep 13, 2009 | Microsoft OFFICE 2003 BASIC OEM ENGLISH MS...

1 Answer

Using Microsoft Query to bring Access 2007 data into a spreadsheet


Try using Data > From Other Sources and select From Microsoft Query. In the Excel sheet, select the cell that you want the results to start in. Your MS Query would be pulling the data from your Access database.

May 04, 2009 | Microsoft Excel for PC

1 Answer

How to get 1 value from report to another form in ms access


You'll have to use a separate Group By query to get the summed data you are looking for, you cannot pull it off the report.

Feb 06, 2009 | Microsoft Business & Productivity Software

1 Answer

Application of Pivot table & Sub total with Examples


Suppose you have a Database regarding sales of this Month inthe Column and Row Fromat with column Heading SalesPerson, Company, Product and Amount. where salesperson sales to different company different Products more than once. In this type of Database Salesperson, Company and Products appears more than once. Now you can use PivotTable to view and analyze your data in different Formats like Salesman wise COmpany wise and Productwise with different formatting REports with a facility of Preparing Charts too.

Dec 03, 2008 | Business & Productivity Software

2 Answers

Excel formulas


Here is your formula

=IF(A1 < 25,10/100 * B1, 5/100 * B1)

A1 is the Age of client
B1 is the car value


Oct 27, 2008 | Microsoft Excel for PC

1 Answer

MS-Access


Open the report is design view maximize the screen, in the open space right click. this will open the properties of the report as a whole. click on the all tab you will now look for the data source. you will see a drop down arrow next to the box that says table1. Hit the drop down box and you will see a list of all querys and tables selct the table you want. The report will now access a new data source. You will want to save the report as a new name or else you will not have two reports you will just have changed the first one.

Sep 17, 2008 | Business & Productivity Software

1 Answer

Excel Pivot view


Highlight the entire pivot table and name it as a range. Then in the formula, replace the reference to the table addresses with the range name. Then wherever you move the table (move, not cut and paste) it will automatically gather the right data. Thanks for rating FixYa!

Oct 19, 2007 | Microsoft Office Standard for PC

4 Answers

Running SQL queries on Excel


Another way to do it is to use the SQL Drill freeware Excel addin (http://www.sqldrill.com)
hth

Aug 14, 2007 | Microsoft Office 2003 Basic Edition...

Not finding what you are looking for?
Microsoft Office Excel 2003 for PC Logo

Related Topics:

121 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18304 Answers

Tony

Level 3 Expert

2598 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...