How to Create a Line chart for Selected companies

[#1]

Hi,

I have to create two line charts

The data for the 1st chart is all the companies in the group which i have created

In the 2nd i have to use the same data but for selected companies, i tried using "Sum ({<ATC3={$(=[A10N])}>} [LEUData])" formula, here ATC is the Field name and [A10N] is of the the Company, but its not saying no data to display,

Can any one help me on this,

Thanks in advance

[CELAMBARASAN]

Hi,

     Comparing the field value should not be within $()

     Sum ({<ATC3={'A10N'}>} [LEUData])

Hope it helps

Celambarasan

[#3]

Hi Celambarasan,

Thanks for your reply i have around 10 companies can you tell how to change the syntax

[CELAMBARASAN · Accepted solution]

Hi,

     You can add companies by comma in between them

     Sum ({<ATC3={'A10N','A20N','A30N'}>} [LEUData])

Celambarasan

[#5]

Ayyyyyy ur syntax has worked thanks alot for your help