More summary columns in a pivot table?

Copper Contributor

Hello community,

I have a pivot table with the summary of the columns:

2019-05-16 16_24_08-Pivot testdata en.xlsx - Gespeichert.png

The problem is, that he calculate all columns (effort and cost, lan and actual) in one value.

I need this in separate columns, separete in plan, actual, separate in effort and cost. Here I have a faked pivot-table:

2019-05-16 16_28_04-Pivot testdata en.xlsx - Gespeichert.png

How can I do this?

I have attached the original excel file.

Thank you very much!

    Michael

0 Replies