Crosstab formula

[former_member366557]

hi sir / madam,

i am new of using crosstab , please help me , all i want is for e.g

               sales1               sales2        difference     total

apple        10                         15               5             25 

milk          10                         15               5             25

my problem here is the difference of the two column i dont know how to do it like this,

thank you

Regards

Silent

[abhilash_kumar]

Hi Silent,

1) Right-click Sales 2 column header > Calculated Member > Insert Column

2) Right-click the Blank header cell that was inserted > Calculated Member > Edit Header formula > Type in:

'Difference'

3) Right-click one of the zero valued cells in the new column > Calculated Member > Edit Calculation Formula > Use this code:

GridValueAt(CurrentRowIndex, CurrentColumnIndex-1, CurrentSummaryIndex) - GridValueAt(CurrentRowIndex, CurrentColumnIndex-2, CurrentSummaryIndex)

-Abhilash