Summarize unique records across several months

[Tseug]

Hello!  I'm probably making this harder than it is, but here goes.  In a crosstab I have a Headcount value that I total for each month on a report that is running YTD.  Let's say that only one person is to be counted each month from Jan to May.  The total for each month would be "1", but the YTD total is "5" - which is obviously wrong.  How do I get the Summary value to only count unique records in each month?  Thank you in advance!

[blom0344]

For a relational package you should be able to use a measure like:

Code Select Expand


total (distinct [person] for [some_dimension])


and use this for the YTD node