Counting Totals but disregarding specific Dimensions

[Anonymous]

Hi

Can someone help me with the following:

I have this expression

COUNT(DISTINCT{<[Task AMS First creation Volume Flag]={1},[Gate DRD]={1}>}[AMS Document ID])

And the data is currently shown by month and Country Region

I want to show the data in another table by YTD, but i don't want the Month dimension to effect the YTD

Hope this makes sense.

Thanks in Advance

[dplr-rn]

add Month= in your set analysis

[vishsaggi]

As Dilip suggested use your monthfield like below:

= COUNT(DISTINCT{<[Task AMS First creation Volume Flag]={1},[Gate DRD]={1}, MonthField=>}[AMS Document ID])