Results 1 to 3 of 3
  1. #1
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    My first work with PIVOT tabel (2000 sr 1)

    why not summ IMPORTO
    Sorry for dimension of file...
    http://www7.rapidupload.com/d.php?file=dl&filepath=2143

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: My first work with PIVOT tabel (2000 sr 1)

    Sal,

    It is not necessary to include all rows in a workbook, the problem can be illustrated as well with a small number of rows. Moreover, the pivot table in your workbook is based on data from another workbook (INPS_2.xls), not on the data in the RATE worksheet.

    The values in the IMPORTO column are text values - this problem has been mentioned several times here and in other discussion forums. Excel treats text values as 0, so all sums are 0 in your pivot table.

    For the moment, you can solve it as follows in your own workbook:
    - Select an empty cell on the PIVOT_RATE worksheet.
    - Press Ctrl+C to copy the cell to the clipboard.
    - Select F3:F804 on the RATE worksheet.
    - Select Edit | Paste Special...
    - Click Add, then OK.
    - Switch to the PIVOT_RATE worksheet and click somewhere in the pivot table.
    - Click the Refresh Data button on the Pivot Table toolbar.

    For the future, it's better to import the data as numbers by using the Val function - this has been discussed in your threads before.

  3. #3
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: My first work with PIVOT tabel (2000 sr 1)

    ... PERFECT!
    work saved "in extremis"...
    Tks.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •