Crosstab display string

[former_member598415]

Hi Team,

I have a cross tab report where I am calculating subtotal in row, but in a column I have to calculate change percentage. And all these value are coming from one column of crosstab.

[abhilash_kumar]

Hi Deepak,

Please try these steps:

1. Right-click the existing 'Total' column cell and select 'Calculated Member' > Insert Child

2. Right-click the blank white space to the top left of the crosstab > Advanced Calculations > Calculated Member.

3. Highlight the first member in the 'Calculated Members' list and select its 'Insert Evaluation' to 'After'. This should move the new column that you just inserted to the end of the crosstab but to the left of the "Total" column

4. Right-click the blank header cell in this new Column > Calculated Member > Edit Header formula > Type in:

"Change"

5. Right-click one of the zero values in this new column > Calculated member > Edit Calculation formula > use this formula:

If GridValueAt(currentrowindex, currentcolumnindex-1, currentsummaryindex) = 0 then 0 else
(GridValueAt(currentrowindex, currentcolumnindex-2, currentsummaryindex) - GridValueAt(currentrowindex, currentcolumnindex-1, currentsummaryindex)) % GridValueAt(currentrowindex, currentcolumnindex-1, currentsummaryindex)

-Abhilash

[former_member629712]

Hi

Could please show me how you calculate the percentage in crosstab?

Because I get a requirement to calculate percentage in crosstab but I didn't have any idea how to do that.

Please help.

Thanks.