What is pivot table and how to create a pivot table

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 do you mean by provider?

1 Answers  


It is possible to access Text (x.txt) files? Explain.

0 Answers  


Is a foo VBX/DLL available as shareware/freeware?

0 Answers  


What is the difference between adodc and adodb in vb?

0 Answers  


what is the property to resize a label control according to your caption?

1 Answers  






What are the types of API Types?

3 Answers  


what is different from edit and updates?

15 Answers   SoftTech, Wipro,


Which language is used in visual basic?

0 Answers  


How to declare Dll Procedure?

1 Answers  


Is visual basic c#?

0 Answers  


Which property of textbox cannot be changed at runtime?

1 Answers  


How would you define and use a Boolean in VB?

2 Answers   Asteroid Software Services, Microsoft,


Categories