Make Date and sleeted last 10 days based on reload time

[anuradhaa]

Hi i have three columns

Year - YYYY

month - MMM

Date - DD

i want to select last 10 days (exclude reload date) if reload date is 21 i want to date 10 - 20 data.

i want to put this is dimension in pivot table.

[#2]

Create a calculated dimension as follows

if ( Date >=floor(ReloadTime()-11) and Date < floor(ReloadTime()), Date)

[anuradhaa]

here i don't have date colum,

i have three columns as year,month and day. need to combine them

[#4]

Ok. then try this.

if (  Date(Date#( Year&month&Day,'YYYYMMMDD'),'DD/MM/YYYY')

>= floor(ReloadTime()-11) and Date < floor(ReloadTime()), Date)

and Date(Date#( Year&month&Day,'YYYYMMMDD'),'DD/MM/YYYY')

<  Date < floor(ReloadTime()), Date(Date#( Year&month&Day,'YYYYMMMDD'),'DD/MM/YYYY'))

[anuradhaa]

not working

[#6]

can you show me your script pls.

[anuradhaa]

it's working, tx

[#8]

if working, can you mark this thread as "Answered" to bring it to a closure?