Joined: 20 Feb 2014
Online Status: Offline
Posts: 5
Topic: Cross-tab Posted: 20 Feb 2014 at 8:32am
Hi,
I created a cross-tab totaling loan amount by month and interest rate. I then created a subreport with another cross-tab totaling trade amounts by month and interest rate.
Is there a way to subtract all the totals on the first cross-tab from the second cross-tab? My goal is to creat a third cross-tab with the net totals.
Joined: 28 Jul 2014
Location: United States
Online Status: Offline
Posts: 5
Posted: 29 Jul 2014 at 8:46am
Kev,
You would need to make the first one a subreport also.
Then create duplicate subreports of each one of those. The duplicates would have shared variable formulas to bring back to be used in the third cross-tab on your main report.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum