same values in Table

[sannidhikumar]

Hi All ,

when i am drill down from Area to LOB i am getting repeated values in table how to resolve this issue.

please find the below attached photo copy and i am using this expression

Round((Sum (CustomerLedger_vw_QlikView.OpenAmount_USD)/sum(Metric))/FX_CONV_RT) .

thanks ,

[Anil_Babu_Samineni]

How you are drilling to next field? Would you tell us the issue to troubleshoot. Because, here we are seeing the Buckets. Could be the reason

[sannidhikumar]

Anil ,

i am drill down from Area to LOB using buckets in the table .

for every buscket i used the expression which i mentioned above .

thanks ,

[goro2010]

You need to exclude the filter Area.

Try this:

=Round((Sum {<Area=>} (CustomerLedger_vw_QlikView.OpenAmount_USD)/sum(Metric))/FX_CONV_RT)