Getting previous quarter value showing current quarter in dimension

[#1]

Hi Team,

I have taken sample QVW from one of discussion.

I need selected dimension with previous quarter value in expression. When I use previous quarter in expression dimension is also changing to previous quarter.

So in example I have selected 3 but selected quarter is showing as 2.

I have many dimesions, if I use getselectedvalue function it in dimension not working in some cases.

Regards,

Sai Krishna.

[sunny_talwar]

This?

Expression:

Above(Sum({<Qtr>}Amount)) * Avg(1)

[#3]

This is not working, I am getting all zeros in real data when I am using the mentioned expression.

max({<QuarterYear={$(vPreviousQaurter)}>}[Cost]), this is showing both quarters Q4 and Q3.

QuarterYear = Q4'16

vPreviousQaurter= Q3'16

[sunny_talwar]

Have you opened the application I have attached above? I am not sure what 0's you are talking about? Can you elaborate?

[#5 · Accepted solution]

Hi Sunny,

Above function is fetching correct results but in my case it is not working. As the there was blank in first row of my data the entire column is showing blank. I have used below expression and it worked fine. Thanks for your help. 🙂

=Aggr(Max({<Quarter={$(vPreviousQaurter)}>} Amount), RecordKey)

Regards,

Sai Krishna.