how to divide all values with a fixed value ?

ChrisM

Well-known Member
Joined
Jun 11, 2002
Messages
2,128
Pivot table formulas confuse the heck out of me. There may be an answer for your question, but I personally find it much much much easier just to create the formula in the raw data (as a new column), and add it to the pivot table range.
 

ChrisM

Well-known Member
Joined
Jun 11, 2002
Messages
2,128
I think you misunderstood, don't create a formula right next to the pivot table, put it next to the raw data that the pivot table draws from, then change your pivot table range to include the new column of formulas.
 

royUK

Well-known Member
Joined
Jul 24, 2002
Messages
1,605
If any moderator picks this up, take note that i have just banned this idiot - fax form Ozgrid for life. He shouldn't be allowed access to any computer!
 

Forum statistics

Threads
1,078,400
Messages
5,339,991
Members
399,346
Latest member
t0land

Some videos you may like

This Week's Hot Topics

Top