Difficult but is it possible?Urgent

[n1ef5ng1]

Here is the scenario, the value of my database is call Transit_Sales.

sum({Name = {'KITTY'}>}Transit_Sales

However, some tweaking of the value is needed to get the actual value due to data are not clean.

To get actural Transit_Sales value, I need to filter in by doing.  

sum

(Aggr(Min(Aggr(sum({<Name = {'F'}}>}Transit_Sales,Vessel_Call_Number,Transit_ATB,Vessel_Name)),Month_Year,Vessel_Name,Vessel_Call_Number))
-
sum({<TXIT_Group_Port_Code.Load={'SGSIN'}>}Transit_Sales)

Therefore with this expression, I am able to get the actual Transit_Sales figure if I use sum(Transit_Sales)

However the problem I encounter is that if I need to use furthur analysis such as finding the sales of a person say KITTY, or a furthur complex such as male gender and age 40 on top of the expression to filter the actual value. Things get complicated.

sum({<Gender = ['M'},Age = {'>40'}>}Sales_TEU)

Is there anyway I can do these codes ON TOP of my filter code on sales_TEU

Much appreciated

[Anonymous]

I would say try to include some part of this in your script itself, that way there would not be much load on the objects. Otherwise i think the objects would take a lot of time to calculate even if you try to put the above expression in a variable and then call that variable with further conditions.

[n1ef5ng1]

somehow I am not able to touch on the script. Any way I can do it in user interface