Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have 3 transaction tables:
1)Daily sales
2)monthly sales
3)target sales
How can i create common calendar for this, what filed i have to use in my reports expressions.
My date field is only one that is "SalesUploadDate".Please find the attachment
can anyone know this ..
regards,
baru
TempCal:
Load
Date as CommonDate
from Daily sales
concatenate
load
Date as CommonDate
from Monthly sales
Concatenate
Load
Datefield as CommonDate
from target sales;
MasterCal:
Load
Commondate,
Year(Commondate) as CommonYear
Month(Commondate) as CommonMonth,
..
,
.....
resident TempCal;
drop table TempCal;
you can calculate any field from Commondate in Mater Cal
hope this helps
TempCal:
Load
Date as CommonDate
from Daily sales
concatenate
load
Date as CommonDate
from Monthly sales
Concatenate
Load
Datefield as CommonDate
from target sales;
MasterCal:
Load
Commondate,
Year(Commondate) as CommonYear
Month(Commondate) as CommonMonth,
..
,
.....
resident TempCal;
drop table TempCal;
you can calculate any field from Commondate in Mater Cal
hope this helps
Hi SK C,
Thanks for reply,
i have a dought,in my reports i am calculating one column is for monthly sales it is from monthly sales table,
one column is for target for months it is from target table,one column for daily sales it is from daily sales table.
which field i have to consider for different columns,it will get duplicate records.
please help me,
regards,
baru
you try using flag for all three tables
like
Monthly as flag
daily as Flag
target as flag in all three table
and calculate your sales based ion flag
Hope this helps
ThankYou SK C,
can i have one example for this and example for expression how to write in the chart level.
For understanding the concept,
regards,
baru
sum({<Flag={'Monthly '}>}SalesAmountFiled)
sum({<Flag={'Daily'}>}SalesAmountFiled)
sum({<Flag={'target'}>}SalesAmountFiled)
hope this helps
Thankyou SK C,
Hi, SK C
I have seen the solution. You concatenated three tables.
Monthly
Daily
Target.
Among these three tables Target table fields are not maching with daily and monthly table fields. So can you tell me how can we concatente if there are dissimilar
fileds b/w two fileds. Please suggest me.
Thanks in advance.
we can concatenate without field mapping also
hope this helps