month before at expretion

[Anonymous]

hi,

i want to calculte sum(kg) , 1 month before my choice ,exm:

if i chose may 2014 , the resolt shold be april 2014.

sum(kg).

thanks'

yarin

[ashfaq_haseeb]

Hi,

Your request is not clear.

Can you attach some sample app with expected output.

Regards

ASHFAQ

[Anonymous]

hi,

attached no but show exm:

i have pivot with 2 columns.

at the exp. i write sum(kg).

i chose period foe exm. may 2014.

at the first coulmn i expect to see sum(kg) for may 2014,

at the secend coulmn i want to shoe sum(kg) for april 2014 - always the period before my selection.

hope it's o.k. now.

thanks'

yarin.

[aveeeeeee7en]

Hi

See this:

Comparing Current Month and Previous Month Sales

It will fulfill your requirement.

Regards

Aviral Nag

[ashfaq_haseeb]

Hi,

Try something like attached.

Regards

ASHFAQ