Trellis pie chat with conditions

[kushalthakral]

Dear All

i need to create a trellis pie chart for the data below:

one more column is company

so i need to calculate for particular company all models in trellis based on year

Year	Model	Sales
2009	A	300
2009	B	400
2010	A	200
2010	B	100
2011	A	355
2011	B	200

i am using expression like

=sum({<[Company]={X}>}ModelCount)/sum(Total {<FinancialYear,[Vehicle Type]={X}>} ModelCount)

Regards

Kushal

[its_anandrjs]

You have to calculate like

=Count( {<[Company]={'X'}>} Model ) / Count(Total {<FinancialYear=,[Vehicle Type]={'X'}>} Model)

[kushalthakral]

Hi Anand

But ModelCount is my field name and i m counting in Script itself

can you tell me the sample expression if we gave two conditions in sum for Trellis

[its_anandrjs]

If ModelCount is a field then it will ok but in second script FinancialYear is a field if so then use it like FinancialYear= for bypass because you cant use it like FinancialYear

But try to check that it is working script

=sum({<[Company]={'X'}>}ModelCount) / sum(Total {<FinancialYear=,[Vehicle Type]={'X'}>} ModelCount)

[kushalthakral]

i have tried but it is not working

Can u plz help me in achieving that

[#6]

Hi

Did u want to achieve somewhat like this.

[kushalthakral]

Hi all

Thanks for ur support

i have found out the solution