Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
How to show a pivot table with yesterdays report default , and should also work accordingly to the from and to calendar.
please be more elaborate with u r requirement. with some example.
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.
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))