Ytd by month on pivot table

[berkarmagan]

Hi,

I have a question and i ll try to tell basicly; I have a data table which contains products, dates and amounts and list box of month. I want to show amounts by month but ytd of month on pivot table. I mean imagine that in january amount is 10, in feb is 15 and march is 10. I need to show if user pick march on list box , i sould see just march on month column and calculated data should be 35 in pivot table. On the other hand if user pick february and march on list box i should see both februrary and march on month column and calculated datas should be 25 and 35.

I atteched a word file which has details about this story.

Regards and thanks for now.

[Anonymous]

Try calculating YTD in the script itself and bring them in pivot or straight table

use expression like this

load *,

if (month = Jan , value,value + peek(value) ) as YTDvalue

resident TableName

groupby col1,col2 etc;

hope it helps

Sri1

[berkarmagan]

Thanks but, i want to calculate it on pivot table, i va already lots of calculation on script side but thanks.