In a pivot table i like to calculate a few values from every order. A order is as big as the next order starts. So between two order there are empty cells. Is it possible to calculate a order until the next order?
In a pivot table i like to calculate a few values from every order. A order is as big as the next order starts. So between two order there are empty cells. Is it possible to calculate a order until the next order?
If I understand then the following three changes will produce what you want:
1. Fill in the blanks in the Order column (C). This could be done by selecting C4:C1117 > selecting Find & Select > Go To Special > Blanks > Press the = and up arrow and Ctrl + Enter keys
2. Change the field setting for the Datum column (on the pivot table) to min.
3. Change the field setting for the NTU column (on the pivot table) to average.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks