selected values

[sakamsureshbabu]

in my  exp i need selected sum like

sum(total)

but total value based on  "bill type = B "

how can i get

[MK_QSL]

SUM({<[bill type] = {'B'}>}total)

[Agis-Kalogiannis]

Set Analysis is the syntax you are looking for Suresh

sum({$<[bill type] = {'B'}>}total)

[its_anandrjs]

You can write with if expression also i assume total is field here

SUM(if( [bill type] = 'B' , total ) )

Or

SUM( { < [bill type] = {'B'} >} total )

Regards

Anand

[sakamsureshbabu]

hi

it is not work

(SUM({<BILLCATEGORYNAME = {'GOLD BILL'}>}BILLGROSSAMOUNT)/AmtFlag)

-

(SUM({<BILLCATEGORYNAME =  {'[GOLD BILL]'}>}BILLDISCOUNT)/AmtFlag)

this my exp is correct

[sakamsureshbabu]

hi

it is not work

(SUM({<BILLCATEGORYNAME = {'GOLD BILL'}>}BILLGROSSAMOUNT)/AmtFlag)

-

(SUM({<BILLCATEGORYNAME =  {'[GOLD BILL]'}>}BILLDISCOUNT)/AmtFlag)

this my exp is correct

[Agis-Kalogiannis]

Hi Suresh

I see that you have some extra square brackets there on the second expression

Try the following:

(SUM({<BILLCATEGORYNAME = {'GOLD BILL'}>}BILLGROSSAMOUNT)/AmtFlag)

-

(SUM({<BILLCATEGORYNAME =  {'GOLD BILL'}>}BILLDISCOUNT)/AmtFlag)

You need to know though that Fieldnames and values are both case sensitive.

Agis

[sakamsureshbabu]

thanks agis it is working

[its_anandrjs]

Hi,

In first expression you use 'GOLD BILL' but in second it is with [GOLD BILL] you have to take exactly same field string available in the BILLCATEGORYNAME then it will works

try to check this if it is GOLD BILL

(SUM({<BILLCATEGORYNAME = {'GOLD BILL'}>}BILLGROSSAMOUNT)/AmtFlag)

-

(SUM({<BILLCATEGORYNAME =  {'GOLD BILL'}>}BILLDISCOUNT)/AmtFlag)

Regards

Anand

[sakamsureshbabu]

HI

my dimension  is ornament but i want show in pivot table with selected "brand"

condition is "BRAND=Y"

how can i show