Dimensions and Facts are properly related. here date field was in 'MM/DD/YYYY' format.

Thsnks,

Suresh.

thanks for your reply...

but here it has parent child relation and i am able to display the parents as columns but data that is childs are not updating...

please suggest me.

thanks,

Suresh.

Please find the attached document.

its a tablex text box

sorry correct total is 4100

3000 + 1100 = 4100.