Click here to Skip to main content
15,887,267 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
HI, I am using Crystal reports version x1. I can't see a calculated field to use in the cross tab.

I have a created a cross tab that shows the number of times an FAQ Title is used for either one month or multiple months. The months are shown in the Column heading and the FAQ Title is shown in the Rows. The summarized field is a count of crystal_txt.Title

If an FAQ Title is showing say 681 times used for July-16 then I want to add another column next to this one that has 30 in it and another column next to this that shows the result of 681 - 30 ie 651.

Then I want to show another column that has $17.60 and then another column that has the total cost ie $17.60 x 651 = $11457.60

times used by month threshold chargeable Cost Total cost
FAQ Title 681 30 651 $17.60 each $11457.60

There would be multiple rows each with a different usage by month.

Thanks,

Mark

What I have tried:

I ave tried to find a Calculated Field to use in the Cross tab, I think version 14 may have it but not version x1.
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900