see the attached
it returns this
I broke it into steps - you can combine
first I dropped in an Index set up like this (note the setup on all the table cals is the same)
Next I used a modulo expression to separate the Odd index from the even the expression returns the remainder of the Index divided by the integer that follows the %
in this case 2
then this expression does the avg and places a null in the second record of the avg
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Sample Tableau Workbook_v10.2.twbx 102.9 KB
Jim, your answer has done wonders to my workbook! Thank you so much for dropping by! I've marked your answer accordingly!
Glad to help out
Modulo is a function that is not documented but comes in handy