Issue

[vipingarg23]

Hi Team,

Please find the dummy data as an attachment.

Requirement:

I have one dimension YearQuarter and two expression A1 and B1.

I want to calculate B1 expression in such a way that whatever data i have in A1 for YearQuarter=2016Q1 that should come in B1 for YearQuarter=2016Q2 and whatever data i have in A1 for YearQuarter=2016Q2 that should come in B1 for YearQuarter=2016Q3 and so on.

Can anybody give me the solution?

Thanks for your help!!!!!!!!!

[vishsaggi]

Got it. Tx

[neelamsaroha157]

True, thanks for using the right term

[sunny_talwar]

[vipingarg23]

Thanks Sunny for your help.

It is working fine.

[Anonymous]

disregard YearQuarter ? where

[vishsaggi]

In sunny's expression if you see Yearquarter field in set analysis. Using this field in set analysis will disregard any selections in that field.

[Anonymous]

Got it .Thanx.