-
1. Re: Last 4 quarter and previous last 4 quarters calculation
. Indumon Oct 4, 2013 1:58 AM (in response to Piotr Wodkiewicz)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
Piotr Wodkiewicz Oct 8, 2013 1:58 AM (in response to . Indumon)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
. Indumon Oct 8, 2013 10:20 AM (in response to Piotr Wodkiewicz)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.
-
4. Re: Last 4 quarter and previous last 4 quarters calculation
Piotr Wodkiewicz Oct 10, 2013 4:51 AM (in response to . Indumon)Thank you it works perferctly
-
5. Re: Last 4 quarter and previous last 4 quarters calculation
Meenakshi Mohan Pethachi Mar 20, 2017 10:55 AM (in response to Piotr Wodkiewicz)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