How to see preveious month sales by using set analysis..?

[gunji767]

Dear All,

I have stored the Month filed in variable, then i used this variable set analysis. While selected the month from the list box chart will be reflected for selected month. It is working fine.

Now i want to show previous month sales details for the selected month from the list box.

used varaible:

set varaible=GetFieldSelections(Month)

Expression for selected month:

=sum({<Month={'$(vMonth)'}>}sales )&'  $(vMonth)'

Can you please help me how can i achieve this requirement.

[its_anandrjs]

Check this

=sum({<Month={"$(vMonth)"}>} sales )&' $(vMonth)'

[its_anandrjs]

vMonth is not the variable where you select the =GetFieldSelections(Month) it is varaible so use this in expression.

=sum({<Month={"$(varaible)"}>} sales )&'  $(varaible)'

[gunji767]

Hi Anand,

=sum({<Month={"$(vMonth)"}>} sales )&' $(vMonth)'

above expression is working fine. I want see show the previous month sales details for selected month.

Thanks

Hareesh.

[gunji767]

in varable place i used vMonth.

Thanks