Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Please find the attached app.
HTH
sushil
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
See attached qvw.
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