Vizualization : Card

Hi All,

I would like to show calculated result of the last day I selected by slicer on the card.

Sales

Date           Sales

1 Apr 2018 20

2 Apr 2018 30

3 Apr 2018 10

.

.

15 Apr 2018 40

Slicer

1 Apr 2018 - 15 Apr 2018

Card

40

Currently card shows total of sales but I would like to show 40.

How can I do that? Appreciate your help.

All the best,

cocomy