are you sure you blended the data sources? In your case you should blend on Product, and possibly on some date measure (if you want to filter by dates). It might be required to set the custom data relationships.
If you would share your workbook it will be easier to help.
But i have to blend the sources on "Item Id" only. Because for any Revenue transaction at project level happened in S1 table then related transaction we make at Cost table for the same project. So i want to fetch that record only right. So have to link with "Item Id".
And cost i am getting it anyways from the source S2 but i am not able to see the data for Other cost from same table.
Lalitha k Prabhala
normally if you data relationship is correct then you just need to make sure when you bring field from secondary source, you need to use sum(Direct Cost ) or any aggregated command.
This is because you may have more than one "Item Id" in secondary source.
Sometimes putting ZN(SUM(DIRECT COST)) works because it handles any null value in the secondary table.