One Field Taking Others Field Data

[#1]

I have Sales field and Bill field,

when I am taking a chart with dimension as year and expression as Sum(sales), the sales bar  is showing the data same as Bill field data, can you suggest me, where might be the problem

[MayilVahanan]

HI

Did you check the table viewer, whether there is a link between year and bill field data?

[#3]

Yes Samy,Bill and year are in the same table only,I am not getting the exact data of the sales year wise    

[MayilVahanan]

Hi

can you please post a sample file?

[#5]

I am posting sample file , in which I have created the sum(sales) year wise charts and gauge charts and also

sum(bill) year wise...you please correct me

thanks,

rams

[MayilVahanan]

Hi

I can't able to find the error in it..

Please see the attached file,,

[#7]

Hi ramasamy ,it is giving same problem..can

[MayilVahanan]

Hi

In the attached image, can you able to view different value for sum(sales) and sum(bill) in year wise.. If its not , can you please say in detail

[#9]

Yes, the values of the sum(sales) and bills are different for both expressions.The sales field is giving is different data when when year is taken as dimension  in my friend system.can you say the reason...

[MayilVahanan]

HI

I think, there may be any mistake in script or something else.. Check like this , in table box,use year , sales fields and export it in both system. and find  any data missing.. or check once the expression also in charts