Need help to calculate trimmed mean from both side


How we can apply trimmed mean in pivote insted of mean.
I have attached image to get an idea.

I don’t believe this is possible natively in quicksight.

If you can, I would look to flag certain values in SQL as out of range and then filter those in QuickSight. However, natively in QuickSight I don’t think we can do it. I can mark this as a feature request.