4 Replies Latest reply: Dec 20, 2016 5:27 AM by Andrea Masciulli RSS

    New field of PivotTable

    Andrea Masciulli

      Goodmorning everyone

      I created a pivot table where a size (Step) is the column header.

      in Table I included the partial sums.

      Now I need to insert an additional column (esperessione) queue where to insert the% of the total value per line compared to the total data.

      the expression forumla know how realizzarla.il problem is that adding an expression in the table Pivot the field is exposed for each phase. (Table 2)

      how can I create an additional column (expression) in the Pivot Table.

      alternatively I could create a linear table, but do not know how to create the subtotals in the linear table.

      Thanks for collaboration