Forum Discussion

slackerhx's avatar
slackerhx
Helper II
8 years ago
Solved

Filter table using TopN results

Hi All,    I've been combing the forums for a solution to an issue that i've encountered. I'm trying to populate a table of details using the TopN selector that i've created. I was successful in po...
Need Help
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi slackerhx,

 

Could you please share a simple? You can upload it to OneDrive or Dropbox and post the link here. Please mask sensitive data before uploading.

 

Best Regards,

Dale

 

slackerhx's avatar
slackerhx
Helper II
8 years ago

Hi Dale v-jiascu-msft, 

 

Please see sample file link below: 

 

https://1drv.ms/u/s!AoVBzNM7bDang2Uu_j-CNH2VlhZT

 

From the file, when you click on the 'TopN' filter the table recalculates subtotal for "Rental Savings". However, i not only want the table to recalculate the subtotals, i also want the TopN to act as a filter to pull out the TopN Lease ID. 

 

Please let me know if further clarifications of my intent is required. 

 

Thank you.