How to get the total from the two different table with single date selection ?

[venkat1]

Hi,

i Had two tables with similar fields ,

Table A having sales 

Table b having Purchases 

Now how can i represent both sales and purchase at a time by selecting date object ?

[Marcos_rv]

sum({$<DATE_SALES={">=$(=Date(vDate1))<=$(=Date(vTDate2))"} >} sales)

sum({$<DATE_PURCHARSES={">=$(=Date(vDate1))<=$(=Date(vTDate2))"} >} PURCHARSES)

vDate1 and vDate2 , son variables, deberias tener calendar object, uno para fecha inicial y otro para final, te manejarias con rangos y esto haria que que tus 2 tablas fact calculen correctamente.

Saludos!!!