Skip to Content
0

Count of Values in one column and showing the Aggregate results?

May 04, 2017 at 04:58 AM

16

avatar image

Hello All,

Attached is snap shot of Raw data details. I need to get to the Aggregate level where need to count the Total Days of Opportunity in each week. For example If WEEK_END_DATE is 03/19/2017 Then it should count Opportunity with 1 as Total 2 days for that WEEK_END_DATE and for 03/12/2017 it should count as 3 and 04/30/2017 should be zero. Please see Expected Result snapshot for desired output. One of the formula I used is below not working. Any input or help is highly appreciated.

=If ([Variables].[Opportunity]=0) Then 0 Else ((Count([Variables].[Opportunity])) In ([WEEK_END_DATE]))

capture.jpg

expected-result.jpg

capture.jpg (55.0 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers