Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
urgent
Hi Khasimvali,
as of your requirement this method is working
=date(Max(datefield)-1,'DD-MM-YYYY')
=date(Max(datefield)-2,'DD-MM-YYYY')
=date(Max(datefield)-3,'DD-MM-YYYY')
use three text box and use this expression.
I think this would be helpful for you...
Hi,
Where Should i Give that Expression? in Variable or pivot table
Thanks
Khasim.
hi Dhiraj,
Where Should i Give the Expression?
Thanks
Khasim.
Hi,
In Pivot table expression.
Regards,
Jagan.
Hi Dhiraj,
I Want this requiremeni in Pivot Table Only given below
on the top of Slide/ Calender Object Need if i Select Date in Calender i want to display given Pivot Table
i Have created created Calender also.
30-May-14 | 31-May-14 | 01-Jun-14 | ||||||
Total | Customers | Total % | Total | Customers | Total % | Total | Customers | Total % |
1106 | Rajendra | 0.40% | 1051 | Ravi | 0.50% | 1101 | Sekhar | 3.10% |
1811 | Raja | 8.50% | 1718 | Rajesh | 2.00% | 1716 | Siva | 2.70% |
Thanks
Khasim.
Hi,
Please find attached file for solution.
Regards,
Jagan.
Hi Khasimvali,
according to your output which you want follow the below instructions-
use date field and other field also in dimention which you want to display in pivot table then in expression use this set analysis
Sum({<SaleDate={'>=$(=Date(Max(SaleDate)-3))<=$(=Date(Max(SaleDate)-1))'}>} Data )
in place of SaleDate use your datefield .
Hope this would be helpful for you.
Hi Dhiraj,
I Tried Your Expression but Not Working you Given Expression
Thanks,
Khasim.
Hi Khasimvali,
Its working please check the attached file
Hi ,
Just a thought, Can we use triggers here ?
Like when getselectedcount(Date) = 1 then select field setexpression (two days back)
Thanks & Regards
Suhas Gupta