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!

Cross-Tab Calculated Member

Status
Not open for further replies.

wanzek

Technical User
Mar 8, 2010
58
US
I am running version 14.0.2.364 (2011 I believe). I am struggling trying to add a calculated member to my cross tab. I know I could do a manually crosstab but it would take along time so I was hoping to do it within a crosstab.

This is how my crosstab is setup:

Setup_oejy4n.jpg


This is the results:

results_bgfjvq.jpg


This report has about 20 columns which could eventually be more but the rows are constant. I need to total the revenue, direct and indirect rows together to get the gross profit. I can't figure out how to total 3 rows and when I try to use GridValueAt I keep getting an error.

Thanks!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top