hi Chinnala,

Is this the same problem as your other post?

Filter having month names of last 6 months using calculated fields

Your action seems to be working for me. If you can let me know what it should do when you click Go, I'll take a look (but think the Pivot Data method is much easier, if you are able to get the data in that shape)

and just to double check!

The Month filters needs to filter the Updated Date on the Update Sheet and the Deleted Date on the Deleted Sheet?

Could well be me...but it looks like it's working!!

I've attached a GIF of it in action (the file I've downloaded from the thread) and it's sorted in the right order and when I use it it seems to show the right information

Now that's the kind of question/answer I like...I just have to open the file on my magic PC!! I don't think I've done anything to the file (I've resaved it, adding a _sr affix)

I'm using in T2018.2

Also let me know if you want to go down the pivot route? Either using your SQL skills, or those in your company...and failing that I can probably* write you out the query (if you let me know what database you are using)

* I've used quite a few databases, so if it uses standard SQL I should be able to help.

very strange. It works on my version (which is exactly the same one I posted back)

In the attached GIF you can see me go into each of the sheets and check the Action Filter is sending August 2018...does yours look like that when you do the same

In the attached (I downgraded this to test on an older version to see if there was some new behavior) I took off the formatting on the [Month Filter] and [DateUpdatedCalc] calcs.  Now they display the full internal value of the respective dates.

I get empty sheets, just like Chinnala reports, both on 2018.3 and on 10.5.

The Month Filter dates all have 30 for the day portion of the date.  the [Date Updated Calc] values all have 1.  Nothing will ever match that way.

Formats don't change the internal values, and that's what Tableau is using in the action filter.

In the attached I added a calc to do a datetrunc on [Month Filter].  This changes the value to MM/01/YYYY.

You can use that instead.

But there was an additional change I needed to make.  I have displayed the value of Calculation1 on the GO sheet.  Initially it was always 10/1/2018 no matter what I set the filter to.

I changed the calc settings for Calculation1 to run along ID rather than Table(down) on the GO sheet.  Now when you select a value, you get the proper value displayed on the GO sheet, and that value gets passed to the Update sheet.  (See filter 3, by the way.)  Previously it was always passing October no matter what you set the filter to, and there are no October rows here.  So you get the blank sheets.