Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a pivot table in which i have to calculate a logic/expression as dimension for %NDFNDR column.. the logic is given below...
the expression is aggregated over test type and measurement type (TT_TYPE,MT_TYPE)
=aggr((Sum(NDFNDR_SUMMARY.TOTAL_FAILURES)/Sum(PRD_OP_DEFECT_YIELD_SUMMARY.TOTAL_DEFECTS)*100),NDFNDR_SUMMARY.TT_TYPE,NDFNDR_SUMMARY.MT_TYPE,
now the problem is:
Sum(PRD_OP_DEFECT_YIELD_SUMMARY.TOTAL_DEFECTS) should not be aggregated over TT_TYPE and MT_TYPE. or other ways TT_TYPE and MT_TYPE should not affect the Sum(PRD_OP_DEFECT_YIELD_SUMMARY.TOTAL_DEFECTS) caculation....
Please help me out,, how to solve this problem...
Thanks in advance..
Please help be guys...
give some idea please..... 😞
HI,
Can you please provide the samplw qvw file.
Regards,
Kaushik Solanki
Hi kaushik,
It is not possible to share the application.. do you have any idea to solve this problem
Thanks
aggr( sum(value),fieldname1,fieldname2,fieldname3)
try to put one by one dimension in aggr
also
check weither are properly made the links
Hi Sunil,
can you explain your solution please.. It is hard to understand
Thanks
check you have propely made a link between table
i mean using proper id
go to control+t and see the link column in both table using rightclick on table preview
if that is ok then
see
aggr( sum(value),fieldname1)
or
aggr( sum(value),fieldname1,fieldname2)
or
aggr( sum(value),fieldname1,fieldname2,fieldname3......