Pls Help to show currrent Year data for present months

[#1]

Hi All,

Attached QVw file for referance

1) I want to display data by default current year data from Jan 2015 to current month i.e.Sep 2015 & don't want to show Oct,nov,Dec month data
    as shown in image. I written 12 hard code expressions for each month which i want to make it dynamic expression.

2) I want to display Rolling 13 months data if i select Year 2014 i.e. Dec 2013 to Dec 2014

Please find attached QVW file for referance n help me on this.

Thanks

[Anonymous]

Hi,

Please try:

Sum({<Year=, Quarter=, Month=, Week=, Date={‘>=$(=MonthStart(Max(Date), -13))<=$(=Date(Max(Date)))’}>} [DTL SUM]/$(vTotal)*100 )

[#3]

Hi Neetha,

I am not getting expected result from your expression please see attached QVW file for

refereance in which i am using only Product as Dimension.Pls help me with QVW.

There are 2 requirement mentioned in main post.

Thanks

[Anonymous]

hi rahul,

Maybe try:

SUM({<MonthYear={">=$(=Date(yearstart(today()),'MMM-YY'))<=$(=Max(MonthYear))"}>} [DTL SUM]/$(vTotal)*100)

[#5]

Hi neetha,

No i am not to get expected result based on 12 expression i want to make dynamic

not with single expression will work. Not using MonthYear as dimension. Pls see attached QVW for ref.

[avinashelite]

try like this :

In the Dimension add a calculated Dimension or you can calculate this column in the script

month([Month Year]) and pivot it.

create one more year column from the Year([Month Year]) as Year_column

In the expression :

if(Year_column=year(today()),sum([DTL SUM]),RangeSum(Above(TOTAL [DTL SUM], 0, 13)))