Skip to main content

I need to implement the following functionality in Tableau:

  1. Grand Total-Based Range Filter
    • The filter should allow users to select a range for <a Measure field 1> based on the aggregated grand total value (e.g., 590 Crs in the full dataset).
    • Users should be able to specify minimum and maximum values to dynamically filter the data within that range.
  1. Sorting by <Measure field 2> (Collection Efficiency)
    • Sorting should be based on the <Measure field 2> Grand total at the same level as the displayed data (e.g., Zone, District, State combined).
    • Users should have the flexibility to choose Ascending or Descending order through a parameter.
  1. Top N Flexibility
    • Users should be able to select the number of top records to display (e.g., Top 5, Top 10, Top 20) based on <Measure field 2> Grand total Value.
    • This should work dynamically with the applied filters.

The goal is to provide a dashboard where users can:

  • Filter by a range of <a Measure field 1> using grand total logic.
  • Sort the view by <Measure field 2> in either ascending or descending order.
  • Display only the top N records based on <Measure field 2>.

Note : Every thing should be implemented on Grand total values.

 

Below I am sharing the Dumb Data.

1 answer
  1. Oct 14, 2025, 12:39 PM

    @Rohit Chauhan​  Were you going to include a TWBX? An illustration of usage-- even if it's hand-drawn, would be helpful.

    Michael Hesser (Tableau Forum Ambassador)

    If this response has answered your question, kindly click "Best Answer"

0/9000