Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
See this application
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 )
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)
I have attached file...
Change expression to $(vTotal)
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.
Must be same in straight table. Even in any other object
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...
See this application
Excellent.... This is what I was looking for.... Thanks for your help