merge or group data in pivot

[Anonymous]

Hi,

in a pivot table we need to do a sum based on week and week_os, but we only want to see the 'merged' result.

Like using a grouping in the calcualtion for week and week_os, but only showing the week.

Here is an example I made in Excel.

Maybe someone can understand, what I am looking for and maybe there is a solution for that.

Kind Regards

Roland

Message was edited by: Roland Walde

[sunny_talwar]

Not sure I understand?

[Anonymous]

it is really hard to explain... I will try to make a mockup in Excel

[Anonymous]

I tried to explain it more in detail.

Pls see the excel screenshot.