I have two excel workbooks having data one with 2015 sales and one with 2016 sale
now I would like to calculate yoy change
I can append the data however as one solution however it is not suitable in our case so blending or custom sql might be the option
can some one please suggest.
Attached sample store file for reference
I think what you probably want is a UNION of multiple Excel files. This is built into Tableau 9.3, which is in beta at this time (see Tableau 9.3 Beta Is Here | Tableau Software ). You might want to sign up for the 9.3 Beta Program | Tableau Software and try it.
Lacking that, there are a few posts with workarounds for older versions. Try searching the Community for the word UNION.