I have an excel spreadsheet that I source from. The first sheet in tableau has the total columns for each dimension. One of the measures is total claim counts. In the second sheet I use a filter which gives me a subset claim counts. The results from this criteria from sheet 2 (claim count) need to a compared to the value in the first sheet (total claim count) and I need to calculate a percent (percent of total claims). Can it be done?
Do you still need assistance with this? If so, can you post a packaged workbook?