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

What are the tools available for Debuggiu in VB?

0 Answers  

Explain the types of Views in Listview Control?

0 Answers   Hella,

Why visual basic is used?

0 Answers  

Difference between Linked Object and Embedded Object?

0 Answers  

What are forms in visual basic?

0 Answers  




How does the following statements work? On Error Resume Next

1 Answers  

what is the Difference between Linked Object and Embedded Object?

0 Answers  

What is the max size of textbox?

2 Answers  

To populate a single column value which dbcontrols you to use?

0 Answers  

What is a variant data type and when would you use it?

3 Answers  

What is data control in vb?

0 Answers  

What is the difference between Msgbox Statement and MsgboxQ function?

1 Answers  

For more Visual Basic Interview Questions Click Here
Categories