I have created a pivot table with some calculated fields about a trip. In this table I would like to attach the same information about the previous and the following/next trip (via drill-down).
So, I'm looking for a solution to calculate a dimension on a specific field (Tripnumber) that shows the previous and next value, related to that Tripnumber and an other field (Vehicle number). Note the previous Tripnumber is not the Tripnumber - 1 !!
you can first organize your table by an "order by", then use in the script previous(Tripnumber) as PrvTripNb to store it in your table.
To get previous and next ,start from 'next' and use previous (previous(Tripnumber)), you get then TripNb as next, previous as current and prev(prev)) as previous
You can then simply use these 3 fields close one to each other
Christian, I can't show a screenshot, because I don't have the solution yet.
I need some kind of structure (where Trip, Related Trips, Loading Location, Unloading Location and Date/Time are dimensions and Kilometers and Hours are expressions) :
Trip
Related Trips
Customer
Loading location
Unloading location
Date/Time
Kilometers
Hours
2
-
A
A
B
9-9-2010 14:00
200
5
1
B
C
D
8-9-2010 12:00
350
7
3
C
E
F
10-9-2010 8:00
600
14
Note: the main line is Trip 2. From this line I need to show the Previous (1) and Next (3) trip with the info about dimensions and expressions.
