Creating Set Analysis expression

[#1]

Hi,

iam unable to create the set analysis expression for this

1)  Sum of all sales where office=4 and CategoryName is Babywear.

2)  Sum of all sales where office=4 and CategoryName is children's wear

please help me out for this expression.

Thanks,

Sudha Banakar

[narender123]

=sum({<office={'4'},CategoryName={'Babywear'}>}sales)

=sum({<office={'4'},CategoryName={'children's wear'}>}sales)

Thanks

Narender

[#3]

Hi,

For me :

=sum({<office={'4'}*{CategoryName={'Babywear'}>}Sales)

=sum({<office={'4'}*{CategoryName={'children'&chr(39)&'s wear'}>}Sales)

Regard

[RedSky001]

sum({$<office={'4'},CategoryName={'Babywear'}>} sales )

sum({$<CategoryName={"children's wear"}>} sales )

[#5]

=sum({<office={'4'},CategoryName={'Babywear'}>}sales)

=sum({<office={'4'},CategoryName={'children's wear'}>}sales)

[#6]

Hi,

Thank u soo much for your guide..

But iam not able to add dimension and expression for this to create a line chart..

x-axis  of the line chart must show year date

y-axis  of the line chart must show sales

please help me out..

Thanks

Sudha Banakar

[rajeshvaswani77]

Add YearMonth in X-Axis and Add the above two expressions for Y-Axis.

thanks,

Rajesh Vaswani