Pivot and grouping total

Hello I have to create a pivot from a set of data but also have to calculate total from one group of data. How can I achieve it in knime .