Help

[panipat1990]

Dear Team,

i Stuck  a Requirement.I have data where three field.Sub_CAT_CD and MC_CD AND QTY.

And One Sub_cat_Code Contain many MC_CD.

If i make two table First Sub_cat_cd wise QTY

Second is MC_CD WISE QTY

Simple Expression Sum(QTY)

But when i select any MC_CD Then First Table Should be should Sub_CAT_CD_WISE QTY WHERE Selection MC_CD_EXIST.

For this i am sharing data.kindly help me

[bohravanraj]

It will be bydefault working same.

if u select any MC_CD then it will only be showing the Sub_CAT_CD_WISE where Selection MC_CD_EXIST.

Regards,

Vanraj Dinesh Bohra

[techvarun]

Can you elaborate more in detail?

Check if the attached helps.

[panipat1990]

Suppose i select MC_CD 111010001.

It Show the QTY 909 it is ok

But this MC_CD Coming Under  This Sub_Cat_CD (1110100) Where Sum show 7300.But 909 is coming Sub_Cat_CD_wise Table. But 7300 shuold be. How is it possible

[panipat1990]

If i select any mc_cd then in Sub_cat_cd wise table show that where this mc_cd exit

[panipat1990]

Suppose i select MC_CD 111010001.

It Show the QTY 909 it is ok

But this MC_CD Coming Under  This Sub_Cat_CD (1110100) Where Sum show 7300.But 909 is coming Sub_Cat_CD_wise Table. But 7300 shuold be. How is it possible

Help

[techvarun]

MC_CD and Sub_Cat having one to one relationship but Sub_Cat  having one to many relationship with MC_CD.

Do you want to show 7300 even if we select MC_CD 111010001 alone?

share the clear requirement with screenshots if possible.

[panipat1990]

yes sir

[panipat1990]

I want to show 7300 even if we select MC_CD 111010001 alone

This is ok ,Kindly help me

[panipat1990]

Hi,

here my data not attached in qvw.