I have a data set in which i have 2106 Q4 data and 2107 Q1, Q2, Q3, Q4 data.
So i need to represent my data in text table in which i should have 3 columns -
1st column - 'Current Quarter' in this i should give them filter option so we can toggle to any quarter.
2nd Column - 'Current Quarter Previous Year' In this if i select 2017 Q4 then it should show 2016 Q4 data.
3rd Column - I should calculate YTD for 2017 Year.
Any suggestion will be really helpful how can we achieve this in single table, because when we give filter for quarters YTD values also i get for that particular quarter. And moreover how can i get Current Year Previous Quarter data according to our selection.Barry PlumAmy SchneiderErin EasterElissa FinkMarc RueterChristian ChabotRicky CoppolaSandy WuDamien Joldersma. joewright@
He has also presented at this great presentation available for watching at your leisure: Think Data Thursday: Dating Rody
I suggest reviewing these for assistance with this.