Cross Tab Report

[former_member557985]

Hello Team,

I have developed a Cross tab report for P/L Branch-wise.

I want to get insert a formula in Cross tab like P/L which will display the difference between Total Revenue - Total Expenses.

How to do it? New to cross tab report...

I have inserted the screenshot . how the report looks like...

[abhilash_kumar]

Hi Deepak,

Are these two separate crosstabs?

Do you want the difference to appear at the end of the second crosstab?

-Abhilash

[former_member557985]

Yes..They are two cross tabs..

Yes..i want to display the difference at the end of the second cross tab...

I was able to bring the total in separate cross tab like this to display the total Revenue & total Expenses:

Is it possible to subtract both the values to get the output below each column.

This cross tab is placed in the Report footer.

[former_member557985]

This is the Cross Tab

[abhilash_kumar · Accepted solution]

You should be able to do this with an Embedded Summary.

While in the preview mode, right-click one of the "expenses" summary value > Embedded summary > Insert embedded summary.

Right-click one of the cells labelled "Edit this formula" > Embedded summary > Edit calculation formula > type this code:

GridValueAt(CurrentrowIndex, CurrentSummaryIndex, 0) - GridValueAt(CurrentrowIndex, CurrentSummaryIndex, 1)

-Abhilash

[former_member557985 · Accepted solution]

Is it possible to contact you through Email?

Still I didnt get the desired output..

[abhilash_kumar · Accepted solution]

Could you please explain or post screenshots of what the issue is?

-Abhilash

[former_member557985 · Accepted solution]

Using the below Formula, I was able to get my desired Output:

if CurrentColumnIndex = 0 then GridValueAt(0,0,0)+GridValueat(0,0,1) else