Diplay max and min date in pivot when dimensions change

[paolojolly]

Hi, I have a table like this

CUSTOMER	DOC NR	SC1	SC2	DATE
CUSTOMER1	20	10%	8%	20/05/2013
CUSTOMER1	19	10%	8%	19/05/2013
CUSTOMER1	18	10%	8%	18/05/2013
CUSTOMER1	17	15%	11%	16/05/2013
CUSTOMER1	16	15%	11%	15/05/2013
CUSTOMER1	15	15%	11%	14/05/2013
CUSTOMER1	14	14%	5%	13/05/2013
CUSTOMER1	13	14%	5%	12/05/2013
CUSTOMER1	12	14%	5%	11/05/2013
CUSTOMER1	11	14%	5%	10/05/2013
CUSTOMER1	10	14%	5%	09/05/2013
CUSTOMER1	9	10%	8%	07/05/2013
CUSTOMER1	8	10%	8%	06/05/2013
CUSTOMER1	7	22%	8%	05/05/2013

in which for every client I have the reference to the document issued by the relevant discounts and I need to create a pivot table like the following

CUSTOMER	SC1	SC2	DATE START	DATE END
CUSTOMER1	10%	8%	18/05/2013	20/05/2013
CUSTOMER1	17	15%	14/05/2013	16/05/2013
CUSTOMER1	10%	8%	06/05/2013	07/05/2013

but with a normal pivot I get the following result

CUSTOMER	SC1	SC2	DATE START	DATE END
CUSTOMER1	10%	8%	18/05/2013	07/05/2013
CUSTOMER1	17	15%	14/05/2013	16/05/2013

can someone help me?

thanks

[sushil353]

Hi,

Please find the attached app.

HTH

sushil

[paolojolly]

thanks, but I do not get what I need.

I need to have a pivot like this

in which I have two records for discounts sc1 sc2 highlighted

[Gysbert_Wassenaar]

See attached qvw.

[paolojolly]

thanks, this solution helps me. But can we have the same result by working only on the pivot table (not at the script level)? Thank you very much