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.
Message was edited by: Roland Walde
May be change it to Straight Table?
thx, that looks good, there is one more thing which makes it more complicated... the dimensions and measures are conditional, the user can decide via button click which to be shown... will check that out, if it also works... moment
and one more: if you collapse dim3, the docind2 should not just aggregated... first it must aggregate the other measures and then calculate on that result, based on week and week_os....