Question about Computers & Internet

1 Answer

Application of Pivot table & Sub total with Examples

Application of Pivot table & sub total

Posted by on

  • de_ranjan198 Mar 07, 2009

    how shall i design any report in pivot table

×

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Corporal:

    An expert that hasĀ over 10 points.

    Mayor:

    An expert whose answer gotĀ voted for 2 times.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 9 Answers

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.

Posted on Dec 08, 2008

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

How do you install a ridgid router to a craftsman router table?


Brenda, They are just saying that if the router is too big, it won't fit. The sub-base is the plastic, usually black, disc on the bottom of the router. This disc is about 6 inches in diameter and about 3/16 inches thick. It is usually held onto the base of the router with three screws. The base is the big aluminum piece about the size of half a loaf of bread that has the handles and into which the router main part (the motor) slides into. For most router tables, you mount a router base (with the sub-base removed) to the underside of the table with screws. The router table becomes a giant upside-down sub-base. If your base fits, and the screw holes line up, you are good to go. However, it is very helpful to have an extra router base (without handles) to leave permanently attached to your router table so that you can easily swap the router between the table and normal use. Good luck!

Jan 13, 2013 | Saws

1 Answer

How do I rename a tax table on my Casio PCR-T2000? I am interested in changing all my registers to the Ontario HST of 13%. Thanks very much.


Use the PGM key and set to PGM. 3, sub total, enter tax table {1, 2, 3, 4}, Tax PGM, 13.00, ca/amt tend, skip to set 'round off/add-on', ca/amt tend, sub total. 4 tax tables are used for the following purposes: table 1 for the federal tax items, table 2 for the provincial tax, 3 and 4 for provincial and different tax table.

Jun 20, 2011 | Casio PCR-T2100 BLACK DELUXE 96-DEPARTMENT...

1 Answer

I am trying to create a pivot table. How can I define to sum of the each field that I grouped ...


Hi

Here are a couple of solutions

Solution A
-click a cell on your active pivot,
-right click, check "grand total for columns" / "rand total for rows"


Solution B
-click on tools customize
-check box "pivot table"
-click on the Pivot Table Tab, down arrow,
-click on Subtotals


regards,
=)

Jan 03, 2011 | ComponentOne VSVIEW Reporting Edition 8.0...

1 Answer

Change tax on casio pcr-360 cash register


Hi,

Bingo!! that's right. The steps are :-

KEY PGM
3 SUB-TOTAL
0125 SUB-TOTAL
( New Tax ) CASH
5002 CASH
SUB-TOTAL
KEY REG

Let me know,if needed further assistance.

Hope i helped you.

Thanks for using ' Fixya ' and have a nice day!!

Jul 11, 2010 | Casio Parts Cash Register PC Desktop

2 Answers

How to change tax rate?


1) switch to PGM mode
2) press 3 then sub total key
3) press 0125 for tax table 1 or 0225 for tax table 2 followed by the sub total key
4) enter tax rate percentage using the decimal point and then press CA/Amt Tend
5) press 5002 and then CA/Amt Tend (to round off results)
6) press sub total key

Apr 01, 2009 | Casio Parts Cash Register PC Desktop

2 Answers

Excel formula creation


= (a3) minus (b3) won't do it for you?

Sep 05, 2008 | Excel (SS8SATAS5128400R)

1 Answer

Data for excel chart


You need to create subtotals so that it looks like something like this:

Prod/units Amt. Level Total

xxxx 10.00 1
yyyy 20.00 1
30.00

dddd 40.00 2
ffff 30.00 2
70.00

etc.

To do this I would suggest using the Pivot Table feature of Excel. It is not too hard to use but you do have to know what you want and also have to be sure you are getting results as expected. Like any tool, it has to be used right. You can also use sub-total functions supplied in VBA as well in your cells.

If you want to avoid using VBA functions in cell and deal with ranges, etc., use the Pivot Table Wizard.

Some reading:
http://www.ehow.com/how_13020_pivot-table-wizard.html
http://www.microsoft.com/dynamics/using/excel_pivot_tables_collins.mspx
http://www.ozgrid.com/Excel/excel-pivot-tables.htm

Also Google "Excel pivot table wizard" to get more.

Good luck!

Feb 23, 2008 | Microsoft Office Standard for PC

1 Answer

Sharp XE-A102 Cash Register


What are you tax tables set up.  This version lets you set up multiple tax tables.  It may be calculating that.

Oct 27, 2007 | Computers & Internet

1 Answer

Restict closing the main form when some controls on the subform are empty


Hi there. I didn't notice this was so old until I had already worked on it for some time. Did you get this the way you want it? If not, I suggest either using a BeforeUpdate control to ensure the condition is met that the subform contain data, or validate the particular field(s) with isnull. Thanks for posting back if you still need help, or otherwise rating FixYa!

Oct 03, 2007 | Microsoft Office Standard for PC

1 Answer

Pivot


Check this out - http://www.cpearson.com/Excel/pivots.htm Basically if you have the data sorted this way: Category Purchases A 12 B 13 A 15 Just select the area go to data -> pivot drag the Category to the Left Row and then the Pirchases to the inside of the table and you have your first pivot table. Let me know if you have any further questions and please don't forget to rate.

Aug 27, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

382 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

kakima

Level 3 Expert

102366 Answers

David Payne
David Payne

Level 3 Expert

14161 Answers

Are you a Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...