Pivot Table Calculated Field using Grand Total

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

diaare - 08 May 2008 22:06 GMT

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

Reply to this Message

diaare - 09 May 2008 14:50 GMT

I have used this site before and have always gotten very quick, thourough and
accurate responses..Thank you thank you!

So, is the lack of response to this due question to the fact that

*my request is not possible,
*we don't know,
or
*we don't understand what you are asking.

Thanks
Diane

> 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
[quoted text clipped - 8 lines]
> thanks
> Diane

Reply to this Message

Herbert Seidenberg - 09 May 2008 19:50 GMT

May be easier if you add
a helper column to the PT source data:
http://www.savefile.com/files/1548235

Reply to this Message

Debra Dalgleish - 09 May 2008 18:26 GMT

You can't tell a calculated field to use the total sum, so it will
always use the sum for the specific category.

Perhaps you can accomplish this with GetPivotData formulas outside of
the pivot table.

> 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
[quoted text clipped - 8 lines]
> thanks
> Diane

Signature

Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Reply to this Message