Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ,
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
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 ,
You need to exclude the filter Area.
Try this:
=Round((Sum {<Area=>} (CustomerLedger_vw_QlikView.OpenAmount_USD)/sum(Metric))/FX_CONV_RT)