Convert Flag table more dynamic by using SET.

[paulyeo11]

Hi

My Objective is to make my Flag table more dynamic by using SET.

My flag table 1 :-

Expression :-

money(

Sum (if($(ColumnDim3), sales)/1000/$(Columndim89))

, $(vMoneyFormatK))

Dimension :-

=if(

aggr(

(Sum (if($(ColumnDim3), sales)) - Sum (if($(ColumnDim4), sales)))  / Sum (if($(ColumnDim4), sales))

, $(ColumnDim101)) <= $(iDiffValues) / 100

, $(ColumnDim101))

I try convert to SET table 2 :-

Expression :-

Sum({$<year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}sales/$(Columndim89)/1000)

I don't know how to convert dimension to SET ( Table 2) , when i turn on current mth and yr , table not working .

Hope some one can advise me.

Paul

[sunny_talwar]

When I click the step 2 button, both the tables don't show anything. Both the tables don't work? What is the expected output?

[paulyeo11]

Hi sunny

I will prepare another new table which is more easy for you to help me.

Pls wait .

Paul

Sent from my iPhone

[paulyeo11]

Hi Sunny

My QV Table.