set Analysis

[#1]

Hi to all,

I have the data from 01 Dec 2008 to 03/02/2015...

if we select any date between these dates,,i want get the data from 01/12/2008 to selected date.

i have two fields like Product and opening Quantity.

for opening Quantity i have to find out that in pivot table.

please give me expression for that.

suppose i selected 01 feb 2015, then i will get the data from starting date to selected date means 01 Dec 2008 to 01 feb 2015.

pls help me

Thannks in advance.

chandra.

[#2]

ok Avinash

thanq.

[#3]

Hi to All,

   I have the data from 01 Dec 2008 to 03/02/2015... if we select any date between these dates,,i want get the data from 01/12/2008 to selected date.  

Above expression is not working pls help me.

I want display data from starting date to Selected date....

I did n't store any dates into variables..

i have my column Posting date,

Pls give me expresion for that...

Thanks for advance

please help me....

[avinashelite]

Hi,

steps:

if your capturing the current selected date in variable then use this expression:

if(datefeild<=$(vcurrentdate),requiredfeild);

or if your selecting the current date in the list box, then

if(datefeild<=getfeildselection(datefeild),requiredfeild);

if your still facing issue please post your app