Data are not visible in certain cases

[nevilledhamsiri]

Please help me on this

By linking couple of different tables, I have done a graph (pie chart). When everything is cleared, data are shown in the Graph. Also in certain centers  data are available but in some centers, it looks blank but of course data are available & are shown in the pivot table only it is not visible in the chart. What could be the case for this. Any easy access to locate the error

Thanks

Neville

[dplr-rn]

are there negative values?

[nevilledhamsiri]

Not really remember. Why is it something really causing this? if so what is the solution?

[dplr-rn]

negatives cannot be handled in pie charts.it fails

hence the question. would need more details or example to help further i feel

[nevilledhamsiri]

Dear Dilip,

Will send you the sample probably tomorrow which data are left in office for further analysis. This is the premium composition by various products which were assigned the ratios based on the total

Thanks

Neville

[dplr-rn]

Sure..

use the same expression as the pie chart in a straight table or pivot to compare.

If data is the issue - in some cases need to identify the records causing issue and analyse that to get to results