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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

CrossTab Querstion

Status
Not open for further replies.

198311

IS-IT--Management
Mar 2, 2006
26
DE
hello,
I hav a question about CrossTab.
Is it possible that I change only Total Field Summary for formula ?? for example :

A B C

2006-02-03 1 2 2
2006-02-04 2 3 3
Total 3 5 5

but i want to have into total a forumla (1+2)*10 ??
When I change something in Total it changes also in other parts of the CrossTab :(

bye,
sorry for my english
 
I don't think you can do that in a Crosstab. What you could do is put a section below the section with the crosstab. Get the same values as the crosstab using running totals, you'll have to do one per column, unfortunately. Then do formula fields that takes the running total and adjusts it using your formula. Display those.

Your English is OK, but you should give your Crystal version, 8.5 or 9 or whatever.

[yinyang] Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10 [yinyang]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top