-
1. Re: Last 4 quarter and previous last 4 quarters calculation
1 of 1 people found this helpfulHello Piotr, This is doable in Tableau and It is easy to get solutions if you upload some sample data or packaged workbook along with your requirement.
However please find the attached sample workbook which calculates and compare the last 4 Qtr sales running total vs previous year.
-
2. Re: Last 4 quarter and previous last 4 quarters calculation
Hi,
Thank you for your help it works on my data but I have two more issues with this.
1) I want to show only one quarter but when I hide other quarters cal stops working. Is there a way to solve it?
2) My Q3 data is not full for 2013 so I want my last 4 quarters to be ending q2 is there a easy way out to filter this and still have the calc valid ?
I think we can use your data set as I can easy move it to my data set.
thanks
-
3. Re: Re: Last 4 quarter and previous last 4 quarters calculation
Hi,
1) I assume you want to show the last 4 Quarter Running sum from the selected quarter vs last year. You can accomplish this by just removing the Quarter pill from the column, calculated field will still return the last 4 quarter total.
.
2) You can control the selection of latest quarter using a parameter and I incorporated that in the calculation.
Updated workbook attached.
-
-
5. Re: Last 4 quarter and previous last 4 quarters calculation
Hi I have some requirement but I have a custom fiscal calendar defined from a separate excel sheet. If thats how can we solve this ? any suggestions wud be helpful
