Hello @pantelis, are you wanting to show 2 different visuals and one is filtered to State A, expense 1, type 1, and size v1 and a 2nd that has size v2? Or do you want to show last 10 appointments for size v1 and 10 for v2 in the same table visual?
If it is a single visual, I would apply the filters for each those options directly on the visual. Then, utilizing denseRank, you can filter to the top 10. Is there a date field in your dataset that we can use to rank? If so, this example should help:
denseRank([{Date} DESC], [], PRE_AGG)
If the visual is already filtered to your required specifications, you can leave the partition field blank. Then you can apply a filter to the visual to only show values less than or equal to 10.
Now, if you need latest 10 appointments for both categories, you will need to add a partition field in the denseRank function:
denseRank([{Date} DESC], [{Size}], PRE_AGG)
Lastly, if your Max Approved, Min Approved, and Avg Approved calculations are LAC-W aggregations and contain the PRE_AGG calculation level, they will all be calculated after the filter is applied to the visual. I’ll attach some documentation below, but let me know if that helps!
One last note, when posting about calculated fields and authoring analyses, can you utilize the author tags rather than developer tags? That will ensure you are more likely to receive a response from the correct QuickSight expert. Thank you!