% of a column total on a pivot table

[mattmarsden]

Hi

I have a pivot table with 2 x Row Dimensions (JAR_MATCH and JOURNEY_TYPE),

I have a column dimension "=date(monthstart((JC_ACTION_DATE)),'MMM-YY')"

I am trying to find the COUNT of the field JC_JOURNEY_TYPE as a % of the column total. I thought that the below would do it.

COUNT(JC_JOURNEY_TYPE) / COUNT(TOTAL monthstart(JC_ACTION_DATE) (JC_JOURNEY_TYPE) ) but this gives nothing.

I tried this:

COUNT(JC_JOURNEY_TYPE) / COUNT(TOTAL <JC_ACTION_DATE> (JC_JOURNEY_TYPE) )

I get the split but across the whole table and not the column only as shown in the image.

If anyone knows how to fix it then it would be appreciated.

Thanks,

Matt

Unfortunately this gives the % of the numbers in the whole table.