sum(if(SeasonShort = vCurrentSeason,(Sales))) [/Code] I want to add a column in my pivot table next to this expression that shows this formula as a percentage of the total. I know if it was a straight table I could use the same formula and just tick the "Relative" box and I will have the Sales as dollars in one column and the sales value as a % of the total in another. Unfortuneatly this isnt available in the Pivot table style which I need. Any ideas? David</body>
