In excel a pivot table has been created with one category and different sub-categories with a total amount by category and sub-category like
In excel it is quite easy to create this table with two entries in ‘rows’ and one entry in values
but with KNIME I am not able to create this kind of output table, I have tried with pivoting node and groupBy node.
I do not know how to realize the category “KTO & Text” with its sub-categories “Profitcenter” with KNIME…
Any help would be very much appreciated.
Thanks a lot and kind regards