1) Can I specify the after range in a specific range? For example, I have 3 ranges in the row(using pipe) and say I only want to use my after range in the 2nd range. Is that possible? Or is there any other way to do that?
2) I want to retrieve my data from January to September without laying their separate IDs. Meaning, I only want to, for example, use "2010.Q3" in a single column. By using YTD, can I retrieve accumulated data from January to September? Or is there any other way to retrieve single but accumulated amount in a single column?
Thank You so much!