Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Can you elaborate more in detail?
Check if the attached helps.
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
If i select any mc_cd then in Sub_cat_cd wise table show that where this mc_cd exit
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
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.
yes sir
I want to show 7300 even if we select MC_CD 111010001 alone
This is ok ,Kindly help me
Hi,
here my data not attached in qvw.