Display all the values excluding maximum and minimum value

[Vigneshvaran]

Hello,

I need to display all the values excluding maximum and minimum Price vale. Please find the excel data source.

[devarasu07]

Hi,

Refer to the attached output.

using below set analysis with date range method u can get the desired out.

sum( {$<Date={">$(=Date(Min(Date)))<$(=Date(Max(Date)))"}>}Price)