display 3 dates if i select one date

[khasimvali85]

urgent

[Anonymous]

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...

[khasimvali85]

Hi,

Where Should i Give that Expression? in Variable or pivot table

Thanks

Khasim.

[khasimvali85]

hi Dhiraj,

Where Should i Give the Expression?

Thanks

Khasim.

[jagan]

Hi,

In Pivot table expression.

Regards,

Jagan.

[khasimvali85]

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.

[jagan]

Hi,

Please find attached file for solution.

Regards,

Jagan.

[Anonymous · Accepted solution]

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.

[khasimvali85]

Hi Dhiraj,

I Tried Your Expression but Not Working you Given Expression

Thanks,

Khasim.

[Anonymous]

Hi Khasimvali,

Its working please check the attached file

[#11]

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