i have pivot table and calendar, By default sum of sales should come by yesterdays date,

[venkat1]

How to show the values in pivot table related to yesterday sales by default,And by changing the calendar values should change accordingly. 

[Vegar]

Try this

SUM( {<
DateField = {'$(=Date(max(DateField)-1))'}
>}Value)

[venkat1]

i had tried , but that was not working.