• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. H

    Show as % difference from in pivot table

    Luke M, thank you. That solved my problem!
  2. H

    Show as % difference from in pivot table

    I have a problem with pivot table, where the column fields are in 2 levels: Year and Item. In the rows area is a City field, and the Amount field is in the Value area. In this case the correct values are summarized for each year. Now I would like to show a % difference from previous year. I...
  3. H

    Listobject total problem

    I found the solution. After setting the total calculation, just turn on, turn off and turn on again the total row. :( Using Excel 2010 .ShowTotals = True .ShowTotals = False .ShowTotals = True
  4. H

    Listobject total problem

    Normally when you add a total row to a listobject manually, they will accept the filter on the table. When I add a total row by VBA: With ActiveSheet.ListObjects("Table1") .ShowTotals = True .ListColumns("Qty").TotalsCalculation = xlTotalsCalculationSum...
  5. H

    Error 1004 Unable to set Numberformat property of PivotField

    My code (fragment): Sub CreatePivotZakazky() Dim PTCache As PivotCache Dim PT As PivotTable Application.DisplayAlerts = False If WorksheetExists("Zakázky") Then Sheets("Zakázky").Select Application.DisplayAlerts = False ActiveWindow.SelectedSheets.Delete...
Back
Top