Skip to Content

Adding a calculated member in a cross tab report

Hi All.

I created a cross-tab report with 2 row fields and date for the columns.
(Cross-tab.png)
I need to add a calculated based on the total of row one.

I right clicked and added a calculated member, but it only does it for the 1st row.

Does this need to be added for each row??

Thank you.
Jerusha

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Feb 05 at 11:22 AM

    Hi Jerusha,

    Right-click one of the summary cells in the newly added Row > Calculated Member > Edit Calculation Formula. Use this code:

    GetTotalValueFor("Row 2") * x.xx

    Replace "Row 2" with the actual field used as the second row in the crosstab. The field needs to be enclosed in double-quotes just like in the example above.

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 02 at 03:22 PM

    Hi Jerusha,

    1. Right-click the new blank row that you inserted > Select Calculated Member > Edit Insertion Formula > Use this code:

    GetRowGroupIndexOf(CurrentRowIndex) = 1

    2. Right-click the blank space to the top left of the crosstab > Select Advanced Calculations > Calculated Member > Under "Properties", look for a radio button with the label "Insert Evaluation". Check "After" for this label.

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Abhilash.

      Thanks so much..That worked (one of the simplest solutions ever :D ).
      The reason I want to add the calculated member, is to also show a calculation based on the total for that group (highlighted in green). The calculation is the total * x.xx%.

      Is this possible through using the calculated member, is the calculated member the right thing to use. I seen some of your previous solutions..But cant seem to get it right.

      Thanks again.
      Jerusha