Please attach the workbook.
Good morning Eric
Could be a lot of things and we would be glad to help out but would need to see your TWBX workbook with the data
I just upload the workbook file, thank you.
I just upload the workbook file with the data, thank you.
Here is what is going on -
you have an order of operation issue - table calculations (and lookup is a table calc) are at the bottom of the order of operation - done last -- Grand Total from the analytics tab are done before the table calcualtions
so when you use grand total on that calculation the only choice is Automatic which means the formula is applied
now getting the total in that formula is problematic - if you can convert the look up to some other type of calculation would be one way - be to use some other table function like window-sum to get the total
which you can convert to this by hiding rows then bringing it to a dashboard and combining it with the other table
sorry but that what is happening
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.