Show All values sorted and grouped in dimension In Pivot Table

[Klaus]

Hi

My pivot table has five dimensions and one expressions.

And here is how it looks.

How can I display in the existing selection to see this?
I don't know how to exploit the dimension 'Nr.bon' to reach the excel result.

[edwin]

is the requirement not to show that field yet preserve the distribution of the expression even when multiple dimension rows are the same?  since this is an aggregation, any duplicate combination of dimensions will be collapsed into one row.

[Klaus]

I accept any suggestion that approaches the excel model, I don't necessarily want to keep all the dimensions

[edwin · Accepted solution]

one of the differences between a straight table and pivot is that in a straight table you have the ability to hide columns.  so you can still use the Nr.bon as a dimension and just hide it.  you will see the individual expression values as if Nr.bon were still shown.  obviously, your year and week will be in separate rows not columns.

if however, the year and week columns (in pivot) were finite, you can simulate these two (for example) columns as separate expressions where using variables (as one solution) your first expression would have something like 
{<[Calendar Year]={$(vPriorYear)}, [CalendarWeekOfYear]={$(vWeek)}>}
2nd expression:
{<[Calendar Year]={$(vCurrentYear)}, [CalendarWeekOfYear]={$(vWeek)}>}

this mimics the pivot table having two columns
=$(vPriorYear) &'
' & $(vWeek)
to look like
2020
    2

maybe that helps

[Klaus]

The method given by you is the most suitable. Thank you for your help!

[edwin]

yw