How to sum distinct value if happend to be in a date range

[#1]

Dear Friends

I want to sum the savings happening in each quarter.

So if a project is ending between 1 Jan 2013 till 31 March 2013, then i want to sum its total.

similar for the rest three quarters.

Really appreciate any inputs on the same.

Best Regards

Rahul Kale

[er_mohit · Accepted solution]

on quartly basis if you want the sum

then use dimension in pivot table as date

and in expression write

if(CalendarQuarter='Q1',sum(total value)

[#3]

Dear Mohit

I have not defined quarter in the script.

Is it is possible with exact date range?

BR

Rahul