Sign Up Login


  1. Categories >> Software >> Microsoft Related >> Visual Basic
  2. Suggest New Category

What is pivot table and how to create a pivot table

Question Posted / guest

Answers were Sorted based on User's Feedback



What is pivot table and how to create a pivot table..

Answer / ruchi

A PIVOT TABLE ALLOWS US TO REORGANIZE AND SUMMARIZE
SELECTED COLUMNS AND ROWS OF DATA IN A SREADSHEET.

Is This Answer Correct ?    8 Yes 0 No

What is pivot table and how to create a pivot table..

Answer / prasanna s chitale

HI, GUYS

PIVOT TABLE IS ADVANCE FEATURE BY SQL ANSI WITH TRANSFORM
STATEMENT. THIS REPRESENTING THE DATA IN CONSOLIDATE WAY.
FOR EXAMPLE IF WE WANT THE PRODUCT V/S MONTHLY SALE ANALYSIS
THEN IT IS POSSIBLE WITH PIVOT TABLE.

MONTH APRIL-07 MAY-07 JUN-07
PRODUCT
MARUTI-800 700 800 550
MARUTI ZEN 100 120 90

ETC

THIS IS TYPICAL PIVOT TABLE

Is This Answer Correct ?    8 Yes 6 No

Post New Answer

More Visual Basic Interview Questions

Types of cursors in DAO?

0 Answers  

Is the Access Engine and Visual Basic Pro good enough for database work?

0 Answers  

___ VB constant make the menu item in centre.

0 Answers  

___ Property is to compress a image in image control.

1 Answers  

Is visual basic c#?

0 Answers  

What is ActiveX Explain?

2 Answers   SDS,

What can you do with visual basic?

0 Answers  

what is the Advantage of ActiveX Dll over Active Exe ?

1 Answers  

Explain about arrays?

0 Answers  

Explain Default cursor Type and LockEdits type in RDO?

0 Answers  

Which property of textbox cannot be changed at runtime?

1 Answers  

What is the latest version of visual basic?

0 Answers  

For more Visual Basic Interview Questions Click Here
Categories