Previous quarter Balance in Pivot

[#1]

Thanks in advance

I have one report which has calculated dimension Q1 2013, Q2 2013, Q3 2013, Q4 2013, Q1 2014

& expression as below.

Previous Quarter Balance  = Sum({<OrderDate = {">=$(=vPrevQtrStartDate) <=$(=vPrevQtrEndDate)"}>} Balance)

Current Quarter Balance   = Sum(Balance)    - This is fine

vPrevQtrStartDate= QuarterStart(Addmonths(OrderDate, - 3))

vPrevQtrEndDate= QuarterEnd(Addmonths(OrderDate, - 3))

I always get 0 for Previous Quarter Balance which is wrong In fact  this should be  Current Quarter Balance from previous column

Your help would be appreciated, Thanks

[#2]

Hi Rajendra

I think it would be easier with Above() function

above([ total ] expression [ , offset [,n ]])

Returns the value of expression evaluated with the chart's dimension values as they appear on the row above the current row within a column segment in a table or, in the case of bitmap charts, in the chart's straight table equivalent

Lukasz

[MK_QSL]

Please check there OrderDate and both variable's return should be in same format..

[sundarakumar]

Please check the values of vPreQtrStartDate and vPreQtrEndDate in a text box...

-sundar

[#5]

Hi Lukasz

I appreciate your prompt reply.

As I am new in QV, could you elaborate more please

Thanking you

Raj

[#6]

Good question Sundarakumar

If I use these variable in Text box, I don’t see any value, but if with formula I can see both correct date

[#7]

It all depends on your data, but if you want to select the value for previous quarter you can use something like this in the chart/table:

Above(Sum(Balance))

[sundarakumar]

Sorry i dont understand, "if with formula i can see both correct date"

where are u seeing the correct date? Please explain.

-Sundar

[#9]

I will try

Thanks a lot lot Lukasz

[MK_QSL]

Kindly upload your sample file or apps...