Which are the companies value is Zero in Top performing Shop

[#1]

Dear All,

the company sells liquors to 7000 shops ,in total there are around 10 companies who are selling liquors to the same 7000 shops. we have found out which are all the shops , which are top shops in selling liquors (all companies brands).

Now the requirement is we need to show all the top selling shops in a bar chart where the liquor sales of a particular company is zero.

i.e., in the bar chart, show only the shops (with total sales) where the liquor sales of a particular company is zero.

Can anyone help me , how do i show the company value is Zero in the top performing Shops.

Regards,

Napolean.

[pover]

You might be able to use the E() function in set analysis. For example, sum({$<Shops=E({1<Company={'CompanyName'}>})>} Sales) which will give you the sum of only the shops that CompanyName did not sell to.

Regards.

[#3]

Dear Karl,

Thanks for your reply.

My requirement is particular company value should be zero on the Top Shop.

Regards,

Napolean

[#4]

Any One can Help me...