Skip to Content
0
Former Member
Jun 22, 2010 at 09:06 AM

WOW QUERRY...

10 Views

Hi experts,

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!

Regards,

Drye