Setting modifier in Set Analysis

[bimala0507]

Hi:

I have a requirement  to show top 10 Materials with Highest Price difference for the period 2012-2013 and for 2013-2014 and I would like to build a dynamic modifier and based on that doing certain calculation.

E.g. If the Current Year Selected is 2012 and 2013 Than calculate

SUM

($(v_netprice_2013) - $(v_netprice_2012))

and

If The Current Year Selection is 2013 and 2014

'

SUM( {} $(v_netprice_214) - $(v_netprice_2013))

Is it acheivable by using Set analysis. Basically I want to select 2 years than it should show me Top 10 Materials for that particular years.

Attached the qvw for your reference. refer Dashboard sheet.

[MK_QSL]

I haven't opened your QVW but let me give you code... you can modify as per your datamodel...

Considering that you will select only two months... you can have growth as per below

SUM({<Month = {'$(=Min(Month))'}>}Sales)

SUM({<Month = {'$(=Max(Month))'}>}Sales)

(SUM({<Month = {'$(=Max(Month))'}>}Sales)-SUM({<Month = {'$(=Min(Month))'}>}Sales))/SUM({<Month = {'$(=Min(Month))'}>}Sales)

[SergeyMak]

Hi,

You don't need to use separate tables for different years.

You need to concatenate tables MAX_PO_XXXX in one table with the same column names and for every concatenated table you should create a Year field with appropriate value of year.

Than you will be able to use set analysis to calculate anything.

For example, Sum({$<Year={$(Max(Year))}>} [net price]) etc....