need help in expression calculation..

[sushil353]

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..

[sushil353]

Please help be guys...

[sushil353]

give some idea please.....  😞

[kaushiknsolanki]

HI,

    Can you please provide the samplw qvw file.

Regards,

Kaushik Solanki

[sushil353]

Hi kaushik,

It is not possible to share the application.. do you have any idea to solve this problem

Thanks

[SunilChauhan]

aggr( sum(value),fieldname1,fieldname2,fieldname3)

try to put one by one dimension in aggr

also

check weither are properly made the links

[sushil353]

Hi Sunil,

can you explain your solution please.. It is hard to understand

Thanks

[SunilChauhan]

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......