I checked "Dropdown select" option in one of the straight table chart, but when a client is selected from the dropdown, it recalculates all expressions based on selected client (which results into all ranks being 1)... I cannot precalculate these expression values as they vary based on selected filters.
Is there any way to simply select a client from the dropdown so that user can review all values for the selected client? And the values will still be calculated based on selected filters?