Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Ranuka ,
Please share your qvw.
Thanks,
AS
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
Can you attach the sample file.
so that we can help you in better way.
Sub2u