How to show (single) delayed orders in existing Pivot table? (not just the count)

[peschu123]

Hi,

I have a Pivot table with Week as Dimension and some expressions. With those expressions I sum orders by their category.

For example I count total number of orders, orders which are on time and orders with delay.

looks like this:

YEAR - Week	2013 - 30
Total	25
On Time	19
Delay < 1 Month	5
Delay 1 to 3 month	1

Now I want to expand the table with rows like this

YEAR - Week	2013 - 30
1st delayed order	'Order No' & 'Order Name' & ' Customer' & 'delay in days:' & [delay]
2nd	'Order No' & 'Order Name' & ' Customer' & 'delay in days:' & [delay]
...
10 ...

Is it possible? And do I have to pre calculate a field for that in the script?

I appreciate any ideas to solve this issue.

- PS -

[peschu123]

Ok. There were no replies, so it seems too complicated or bad described by me. 😞

I didn't found a suitable way, so I chose to insert a straight table below the pivot table, to show more detailed values.