Selected Dates Range

[bharatkishore]

Hi All,

I have a date field from Jan 2014 to Sep 2017.

I need to calculate sum(consumption) from Oct 2015 to Sep 2016

then I need to calculate sum(consumption) from Oct 2016 to Sep 2017

Can you please tell me how can i achieve this.

Attached app for more reference.

Thanks,

Bharat

[tresesco]

Year, Month are taken to disregard the selection in those fields. I.e. the calculation would be only based on MonthYear field's reference (defined in the range expression). Max() is used to tell monthstart() where it should start from to go behind (11 months as you need). For better understanding you might want to learn more about set analysis. Set Analysis: syntaxes, examples

[bharatkishore]

Thank u so much .... thanks for ur time n patience for explaining and thank u so much once again..