Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Crosstab mean price not working

Status
Not open for further replies.

bbduc

Programmer
Feb 22, 2001
2
CA
Could any one help,
How to insert the the mean price per peice into a crosstab?
Please help
Here an example of my cross tab I would like

Parts Qte
Price
1Jan 2Feb
A1 12 20
$12 $10
A2 10 13
$10 $23
$/P $1 $1 <--- I am not able to get the good result
it should calculate the end total$/end
total qte
Row --> Part number
Column --> Month
Data ---> Qte
Price

Thanks for any help

Bd
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top