Accumulated Values in Pivot Table

[renuka_sasikumar]

Hi,

I have MonthName as Dimension & expression are Budget, MTD, YTD, PYTD

For MTD (=Sum(Sales)) I m getting correct value, but when for YTD i have created variables to show data, but its not working.

Its giving the same MTD values.

I want to show Accumulated Values in Pivot Table & Range Sum is also not working.

Can anyone please help me with this.

Thanks & Regards,

Renuka S

[amit_saini]

Ranuka ,

Please share your qvw.

Thanks,
AS

[PrashantSangle]

Hi,

Try like

MTD =Sum({<DateField={">=$(=Date(Monthstart(Today())))"}>}Sales)

YTD = Sum({<Datefield={">=$(=Date(YearStart(Today())))"}>}Sales)

PYYTD= Sum({<DateField={">=$(=Date(AddMonths(YearStart(Today()),-12)))<=$(=Date(AddMonths(Today(),-12)))"}>}Sales)

Regards

[amit_saini]

Check:

http://community.qlik.com/message/480621#480621

http://community.qlik.com/message/532115#532115

Thanks,
AS

[#5]

Can you attach the sample file.

so that we can help you in better way.

Sub2u