2 Replies Latest reply on Apr 13, 2017 11:05 PM by Venkat Gm

By Using Quick Filters How we can get CYTD & PYTD data.

Venkat Gm Apr 12, 2017 11:17 AM

Here i have a Question, I have Emp data In that Date Column DOJ i dragged that field into filter shelf and i selected months, make it as Quick filter "MMM" YYYY" In that I need to Display Only My Current FY related Months Only. My FY starts June 2016 to May 2017. So now we are in Apr, so I will see fields till Apr 2017. If i select May 2016 i need see data May 2016 & May 2015. Current financial year Selected Month Data & previous year Same Month Data we need see. How we can Develop with out Create Parameters. How we create Calculated Fields For this Scenario.

Sample W book.twbx 39.3 KB

1. Re: By Using Quick Filters How we can get CYTD & PYTD data.

Kaz Shakir Apr 13, 2017 12:15 PM (in response to Venkat Gm)

Venkat,
Is this what you are trying to achieve?
Kaz.
Like Show 0 Likes(0)

Actions
2. Re: By Using Quick Filters How we can get CYTD & PYTD data.

Venkat Gm Apr 13, 2017 11:05 PM (in response to Kaz Shakir)

Hi Kaz, thank you for your response

Here My requirement is little different, In Month Filter you choose Multivalue selection, But I need single Value selection.
I mean In Month Selection I need to See Only CY Months. If I select March, I need to see CY March Data & PY March data. In selection, Formate Changed now Default "MMM" format fine. No need "MM" YYYY". (Current FY year Starts June 16 - May 17).

Thank you.
Venkat.
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community

By Using Quick Filters How we can get CYTD & PYTD data.

1. Re: By Using Quick Filters How we can get CYTD & PYTD data.

2. Re: By Using Quick Filters How we can get CYTD & PYTD data.

Actions

More Like This