Preserving YTD after date filter applied
Hi,
We are facing this. We have a pivot table with shows the total amount of a metric and the running sum form the begining of the year (YTD). This is working fine:
Then, we want to apply a ...
Forum Discussion
I generally use an sql window function when importing the table, ie "over partition by..". Given what is shown is a pivot I assume your data does not already look like that so I could not give you the exact query just the method
