Set Analysis instead of IF

[MK_QSL]

I have variable vInvoiceTotal giving total of invoice value.

Data are having three years 2011, 2012 and 2013.

I want to show below using SET ANALYSIS.

  If (Year = ‘2011’, $(vInvoiceTotal))

I have enclosed exaple showing yearwise invoice total using IF.. Need Set Analysis to give the same result in straight table.

[#2]

Not sure what your variable looks like, so the content of the variable might change this, but it would be something like:

Sum({$<[Year]={"=2011"}> YourValue )

[prodanov]

Attach an application!

See data format on field Year, if it is a number you must delete '. If this don't help change formula to $(=vInvoiceTotal)

[MK_QSL]

I have attached file...

[prodanov]

Change expression to $(vTotal)

[MK_QSL]

This is true for Pivot table but how can i get the same result from Straight Table.... There should be four columns.

Invoice No, Year 2011, Year 2012, Year 2013.

[prodanov]

Must be same in straight table. Even in any other object

[MK_QSL]

My question is how to get the same result in straight table using set analysis & variable.

need three different columns for expressions.... i.e. Year 2011, Year 2012, Year 2013...

[prodanov · Accepted solution]

See this application

[MK_QSL]

Excellent.... This is what I was looking for.... Thanks for your help