Hi Shinichiro,

Thanks for the response. Yes it does help. But, lets say if we have both the Beginning and Ending Balance for a Date. How should we write the Quarter Calculation and is it possible to provide the user with a single filter or parameter to show both the Months and Quarters of an year/s so that they can pick month or quarter as per there requirement

Example:

2016 Jan

2016 Feb

2016 March

2016 Q1

2016 Apr

2016 May

2016 June

2016 Q2

.......

Please find the attached image with Beginning and Ending Balance for a Date.

Thank you.

Hi Shinichiro,

My first question, if we get both the Beginning and Ending Balance for a Date field from the query. How should we write the Calculation to get the Beginning and Ending Balance of a Quarter in Tableau.

For example:

Date                   Ending Value     Beginning Value

2017-1-31               10000                    0

2017-2-28               10100                  10000

2017-3-31               10200                  10100

2017-4-30               10300                  10200

2017-5-31               10400                  10300

2017-6-30               10500                   10400

Second Question, As we are showing both month and quarter beginning and ending Balance on a dashboard.

Is it possible to provide a dropdown Date filter which can give an option to select by either month or quarter of a year/s

Please see the attached Images for month/year and quarters filter.

Can we provide a single date filter which has options to select 2017 Jan if they want to see Jan month data or 2017 Q1 if they want to see Quarter 1 data of 2017.  Is there any work around in Tableau?

Thank you.

Hi Shinichiro,

You the Man. Thanks a lot.

Need one last help. I'm attaching my sample workbook. Can you please do the calculations in the attached workbook and reattach the file back so that i can understand without doing union of sheets as I'm getting the data from database.

Thank you.

Regards,

Samanth

Thanks a lot Shinichiro .

Hi Shinichiro,

Need Small help. Please see the attached images.

Question 1) Is it possible when we select the month/quarter filter (ex: 201711 or 2017Q1) to show the entire portfolio balance(i.e; the Ending FV) for the 2017 year for all the months?

Right now I'm using a separate filter for the Portfolio Balance. Is it possible to use only month/quarter filter which works for both the sheets.

Question 2) For the segment premium wine, if I select the 2016 Q3 or 2017 Q1 the End Balance shows as Null. Is there any way we can change the calculation for the Quarter, let's say for 2016 Q3 the End balance should be as of September. But as we don't have any premium wine Value for September can we show the End balance as of August for 2016 Q3 as we have the end balance for August 2016. Similarly, for 2017 Q1 the End balance should be as of March. But as we don't have any premium wine Value for February and March can we show the End balance as of January for 2017 Q1 as we have the end balance for January 2017.

Attached the workbook.

Thank you.

Hi Shinichiro,

Here is the link to the new post thread. It would be great if you can help me out on this.

Thank you.

Quarter Calculation and using a single filter for two different sheets?