Pivot - Show Values As

[tuktuk]

I have a pivot table whose Columns are dates and Values are SumOfTransactions and Rows are Countries

I want to show a % of that months "% of Total" for each month.

If I set the Value Field Setting, Show Values as set to % of Total it is a % of the Grand Total.

How do I make it so it is % of Total for that month.

Thanks Tuk

 

[tuktuk]

oppps % Of Columns willl do it
hahaahahh

took longer to write the msg above than to solve....ahahhah