Hi Kahv Jiv,
I'm not sure I have understood that part: "FY 2014 should display 10, FY 2014 should display 8"
Did you mean: "FY 2014 should display 10, FY 2015 should display 8" and so on: 9, 11, 12?
Your calculation seemed good, I was about to do the same thanks to an advice from Joe Mako in 2013.
Indeed, it doesn't give us what we want here.
I have tried this:
if [Select metrics]="sales"
ELSEIF LAST() = 0
But it doesn't display the values in every columns..
I'll give it a fresher look this week.
Lénaïc RIÉDINGER, Global Community Engineer Tableau
If you see a Helpful or Correct response, please mark it thanks to the buttons below the targeted post!
Hi, I think I confused you. So whatever the last month of that fiscal year is, I want the FY to display the last month.
Example for FY 2014 I have full fiscal year data available ( i have data from Nov 2013 to Oct 2014, my fiscal year starts at nov) so FY2014 should display value of Oct 2014.
For FY2015, i have data available till August 2015, so my FY2015 should display Aug2015 data. When next month comes in it will display Sept2015.
Hope its clear. Thanks!