Help with Pivot table % by day

[davehutchinson]

Hi all.  I'm totally stumped with pivot tables today.  Hopefully someone can spot where I'm going wrong as I just can't understand why my % isn't calculating properly.

So I havae a pivot table that is counting distinct incidents:

Measure: Count(distinct[INCIDENT_REFERENCE])

I then have 2 dimentions in my pivot:

[DAY] and then the category of [Over/Under Estimated Time]

The pivot table with a count looks like this and is correct:

I then want the same pivot table but showing the numbers as a percentage of the day.  Simple right???

So I modified the measure to be:

Count(distinct[INCIDENT_REFERENCE])
/
Count(TOTAL<DAY>distinct[INCIDENT_REFERENCE])

however it comes out with the following results which are clearly wrong:

Can anyone tell me what's wrong with my % measure?  I'm stumped.

[Chanty4u]

Try this 

Count(DISTINCT INCIDENT_REFERENCE)

/

Aggr(Count(DISTINCT INCIDENT_REFERENCE), DAY)

Or

Count(DISTINCT [INCIDENT_REFERENCE]) 

/ 

Sum(TOTAL <DAY> Count(DISTINCT [INCIDENT_REFERENCE]))

[davehutchinson]

No luck unfortunately.

I think I might have to start from scratch.  I'm really stumped with this one....

[davehutchinson]

It appears to be the discinct command that's causing the issue... If i remove it I can get the % to equal 100% per day.... I'm not sure how accurate the numbers are so will investigate!