1 of 1 people found this helpful
Hello 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.
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.
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.
Thank you it works perferctly
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