Fetch take first 10 records sorted by DATE ASC in PIVOT

[gizzel123]

Hi All,

I have a pivot table, I need to fetch 10 rows , based on DATE FIELD  ASC. Also  sorting has to be done  based on DATE .

FYI: DATE field is the 3rd dimension used,  So sort order, expression is not working .

Please help.

Regards,

Shruti