Multiple Calculated Dimensions

[danielnevitt]

Hi,

I'm trying to restrict the data shown on a graph by using calculated dimensions.

The restrictions I would like to apply are:

DESK_CD = Crude AND

INTERNAL_IND <> Inter-Strategy AND

TRADE_STATUS_IND = Finalized OR New Trade OR Parceled OR PL Run OR Realized

Is this possible?

Any help will be much appreciated.

Regards,

Daniel

[v_iyyappan · Accepted solution]

Hi,

U can restrict the filter in set analysis.

Try like this

=Sum({<DESK_CD = {'Crude'}, INTERNAL_IND -= {'Inter-Strategy'}, TRADE_STATUS_IND={'Finalized', 'New Trade', Parceled', 'PL Run', 'Realized'} >}sumfield)

regards,

[danielnevitt]

Thanks for your help.

Regards,

Daniel