i wan to show yesterday sales in pivot table and having from and to calendar

[venkat1]

Hello All,

How to show a pivot table with yesterdays report default , and should also work accordingly to the from and to calendar. 

[HirisH_V7]

please be more elaborate with u r requirement. with some example.

[venkat1]

There was an  pivot table,and year month quarter selections,without doing any selections in pivot table should display yesterdays sales,by changing the selections of year,month and quarters values in the pivot table should change accordingly.

[Anil_Babu_Samineni]

Perhaps this?

If(GetSelectedCount(Month)=0 and GetSelectedCount(Year)=0 and GetSelectedCount(Quarter)=0, Sum({<DateField = {"$(=Date(Max(DateField-1, 'Date Format of Date Field')))"}, Sum(Sales))

Or, If any one the above selections need to reflect use Or condition like

If(GetSelectedCount(Month)=0 or GetSelectedCount(Year)=0 or GetSelectedCount(Quarter)=0, Sum({<DateField = {"$(=Date(Max(DateField-1, 'Date Format of Date Field')))"}, Sum(Sales))