Data Till Current Date with buckets

[Anonymous]

          Hi,I am stuck in one problem

I want to show YTD count and it should be dynamicly change every day along with buckets. That YTD Feild and Buckets are created in Script in that Buckets are working fine and YTD data is created based on Today Function. It is giving correct value for current month but if we move previus month it is showing a same value becouse of today function.Anything alternative of Today function that will helpful

I have attached the Screen shot of requriment how i need this and also i atteched QVW i which i had worked

I want to create this logic in script level only beacouse after this i also need to include more things in my pivot table.

Please help me out to solve this problem i really aprreciate your help

[Gysbert_Wassenaar]

You can find out how to do this in this document: Calculating rolling n-period totals, averages or other aggregations. There's a YTD example in the AsOf Table Examples.qvw file attached to that document.

[Anonymous · Accepted solution]

Hi Gysbert,

Thank you so much i got it.

[vardhancse]

Can please close the thread if you got correct answer. so that might be helpful to another without creating one more duplicate thread on the same.