Advanced aggregation aggr() is probably the way to go, but you might need to rethink which dimensions to use in the advanced aggregation (maybe you need to add Deal_CreatedBy, too, and / or your calendar dimensions).
Also you probably need to add an aggregation function around the aggr(), maybe like
=sum( aggr( count(Deal_TakedownID), Deal_CloseBy))
I haven't fully understood your requirement and setting, it would be helpful if you can post a small sample app together with your expected outcome (e.g. in an excel table).
Thanks for your answer. For example I have the below data :
Account Schedule Number Year Month Created By Closed By 10001 2013 June Melissa Dana 10002 2013 June Melissa Tammy 10003 2013 June Melissa Tammy 10004 2013 June Dana Tracy 10005 2013 June Melissa Regina 10006 2013 June Melissa Melissa
And I want to show data in the following way:
Year Month Created By Total Created # Total Closed# 2013 June Melissa 5 1 2013 June Dana 1 1 2013 June Tammy 0 2 2013 June Tracy 0 1 2013 June Regina 0 1 Total 6 6