There are 2 Variants I have attached below, which has been executed from a single Query.
One is by using 0CALDAY in Columns and other one without using 0CALDAY in the columns. (That means the Report selection parameters is from 23/11/2014 till 30/11/2014 in both the case)
KEY filed in this report is “No of Bins” . This has been calculated by using Formula Variable.
My requirement is, when I execute the report for above period ( 23/11/2014 till 30/11/2014) without using 0CALDAY in columns. The result should appear as 266,880 and not as 44,480. ( Since the KEY field is a Formula Variable it take the latest No of Bins Available and displays only 44,480 in Result)
In simple. I want the KEY field “No of Bins” should Sum up all the values from 23/11/2014 till 30/11/2014. And display 266,880
Requiring Expert Advice to acquire the desired result.
1) Variant 1
2) Variant 2