Hi All,
I want to create a bar graph that shows YOY growth for each Sales Partner.
First instinct was to use the Quick Table Calculation, but I also want to be able to sort by YOY growth, in descending order. I also don't want to show both Year headers:
Would it be easier to create a calculation for YOY growth? How is that done? My data looks like this:
Sales AmountFYPartnerFY_Month$7,0952016ABCFEBRUARY$5002016ABCMARCH$4002016ABCAPRIL$9502016ABCMAY$1502016ABCFEBRUARY$5,1862017ABCFEBRUARY$1,6582017ABCMARCH$7,0512017ABCAPRIL$1,1762017ABCMAY$5222017ABCFEBRUARY
Hey Alec,
I would probably suggest using the Hide Column/Row option and hide the "2016" member (Bring the YEAR([Fiscal Year]) back to rows, right-click on "2016" > Hide) . This only omits the year from the view display, so it won't affect our YoY calculation and will allow us to focus on 2017 metrics.
I personally found that Sorting Using the Toolbar and Tooltips works with this view. I am using a later version of Tableau (10.3) so I am not sure if that was improvements we made to the product after your version or not. Give that a try and see if it works out.
