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

peschu123 — Wed, 24 Jul 2013 09:09:32 GMT

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:

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 -

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

peschu123 — Wed, 24 Jul 2013 15:13:30 GMT

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.