This content has been marked as final. Show 3 replies
I'm trying to recreate an excel spreadsheet for a coworker. I've got all the data lined up correctly in tableau except for 2 Index columns. 1 column is based on Response Rate, and the other AOV. The excel formula takes the first "Cell" for each "List Type" and sets it as 100. It then compares the rest of the Cells to that base number. The formula is included on the attached excel file. I've tried using a generic Index() calc, but I can't seem to aim it at the correct columns.