Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good morning,
I´m trying to select a Field call month that i have in two table, the firts one is an excel table (BUDGET) I make a Croos table (see attached file) the second one (SALES) is in my ERP (Oracle DB) in Both the field is Called T$PERI$O, but when it is showing appear duplicated (see attached File).
I want to select only one month to show me the Budget and Sales for the same Month.
I´ll appreciate your help to solve this issue.
(Please see attache file, where I´m mtrying to explain this case)
Hi,
It seems it's because values from excel are interpreted as strings and from Oracle as numbers or viceversa. Take a look at this post that seems very similiar to your issue.
Hope that helps.
BI Consultant
Hi,
It seems it's because values from excel are interpreted as strings and from Oracle as numbers or viceversa. Take a look at this post that seems very similiar to your issue.
Hope that helps.
BI Consultant
Thanks a lot Miguel, It´s working fine now.....