How to filter the same value as in main sheet button & Variable value

[Aadhini]

THE Excel Data 

2 Sheet in Dashboard Main Sheet and Sub_1 sheet 

IN Main sheet 

1)Button (head)

2) Variable Input -> Variable is Btn 

           under Variable Input  4 Buttons

  this Input variable Button 4 Buttons
Its Label And value is 

 

the actual scenarios are 

First select Any one Button in variable input eg Select R1

In Button it show Head rows Data count of R1 (eg the count of DD in R1 is 2 ,the count of Aa in R1 is 1, )

once click the button of DD Count

open the next sheet 

          in that sheet, the table  rows has  DD count  with R1 
like this 

[FedericoDellAcqua · Accepted solution]

You can use the sheet options to filter the "head" values matching the variable value. 

Otherwise, you could define your "head" dimension in the table like "if( head = '$(YourVariable)', head, null())" and then exclude null values in dimension.