Which view is good for Pivot Table and data management?

March 1st, 2011 by admin admin

span style=”font-family: Arial, Helvetica, sans-serif;”strongQuestion:/strong I have a large data of about 700 columns amp; 4000 rows relating to the sales.Great of columns(fields) are due to no. of sale-able items (About 670)/spanbr /span style=”font-family: Arial, Helvetica, sans-serif;”/spanbr /br /span style=”font-family: Arial, Helvetica, sans-serif;”I have designed the table with each individual sale-able items as separate Fields instead of One field under Item Name as I want to view sales transaction in one record. This is to overcome disadvantage of entering data for party name, bill no, date…etc several times for sales transactions having more than one items./spanbr /span style=”font-family: Arial, Helvetica, sans-serif;”But when I converted the data into Table amp; make use of Database functions like dsum, dget to extract the results, it slows down.Calculation is very slow,even if I open or save the excel file it takes a lot of time./spanbr /br /span style=”font-family: Arial, Helvetica, sans-serif;”I tried pivot table but it didn’t worked As I need to drag and drop almost 650 fields./spanbr /span style=”font-family: Arial, Helvetica, sans-serif;”br //spanbr /strongspan style=”font-family: Arial, Helvetica, sans-serif;”Answer:/span/strong br /span style=”font-family: Arial, Helvetica, sans-serif;”The correct approach is what you have been avoiding, that is, to put the items names under One column. This arrangementnbsp;facilitate the use of Pivot Table to generate results. What you are concerned with, to view transactions in one records cannbsp;still be achievednbsp;in the Pivot Table view, instead of the raw data view. Right not, you have no choice but to re-organise everything in the other view. A macro can be very helpful for this situation./span

2 Responses to “Which view is good for Pivot Table and data management?”

  1. Pawan Says:

    Can u help to re arrange the data view so that I can use pivot table to generate results

  2. JK Says:

    Yes, we can do that for a fee. You can email me at enquiry@synergyworks.com.sg

Leave a Reply

You must be logged in to post a comment.