Skip to Content

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

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers