D
diaare
I have a pivot table of sales data. I need to have a calculated field that
gives me my sales mix. In an excel cell the formula would be =(2007%of
Revenue)*(total2008Sales$)
I have fields in the current PT that give me the % of revenue, and the sales
numbers, but I do not know how to tell the PT how to find the total 2008
sales number (not just the sum of sales for that specific catagory)
Hope this is clear...
thanks
Diane
gives me my sales mix. In an excel cell the formula would be =(2007%of
Revenue)*(total2008Sales$)
I have fields in the current PT that give me the % of revenue, and the sales
numbers, but I do not know how to tell the PT how to find the total 2008
sales number (not just the sum of sales for that specific catagory)
Hope this is clear...
thanks
Diane