This is Strange..We need your workbook to figure it out.
Is the aggregation done in SQL? If so, then you won't be able to see the underlying data. Otherwise, are you selecting "Full Data" (in red below) and "Show all fields" (in blue below)?
If this post 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.
The aggregation is written in SQL. I thought this might be an issue. In order to see the underlying data, does aggregations have to be done in Tableau?
Thank you for your response Deepak!
Yes, to see the underlying data the aggregations have to be done in Tableau. The granularity level at which you want to see the data has to be fed in to Tableau. This will mean many more rows, but it will also give you greater flexibility in working with your data in Tableau.