select particular data

[#1]

Hello,

I have a table as following,

CompanyName	Date	Stock	StockFlag
AAA	2015-07-15	25	-
AAA	2015-07-16	30	Y
AAA	2015-07-16	28	Y
BBB	2015-07-15	16	-
BBB	2015-07-16	35	Y
BBB	2015-07-16	40	Y

I want to only sumary the amount of the stock with condition 'stockflag=Y' by company name and date, my expression is like '

if(StockFlag='Y',sum({$<CompanyName>}Stock),'NA'), is it correct ?

If use 'set analysis' statement, how about the expression ?

Expecting result is like:

CompanyName	Date	Stock
AAA	2015-07-16	58
BBB	2015-07-16	75

Thanks

Jessica

[robert_mika]

sum({<StockFlag={'Y'}>} Stock)

[svenkita]

While creating the Straight Table or Pivot Table

have the

Dimension as CompanyName and Date

and the expression as

Sum({<StockFlag={'Y'}>} Stock)

[SatyaPaleti]

Hi Jessica,

Take CompanyName and Date as Dimensions

in Expression :- Sum({<StockFlag={'Y'}>} Stock)

Thank you,

Satya

[#5]

Hi Jessica lv,

Take Dimensions: Company Name and Date

Expression: Sum({<StockFlag={'Y'}>}Stock) .

Regards,

Kalyan.