TIBCO Spotfire

Hi,

Could you please help me write a custom expression to calculate the cell value of a crosstab or a graphical table.

I want to calculate sales growth for Actual Period by using the following expression.

Sales Growth: Sales for actual period -Sales for Previous Period where Sales is the KPI .

How do i write a custom expression to get the value of Actual period for the KPI 'Sales' which is 256241.48 ?

Could you please help me?

 Try to rearrange the Cross Table then you can reference previous axis.columns or previous axis.rows inside a custom expression

I'm not sure if it is even possible to perform calculations based on cell results in a cross table.

A simple work around I've used in such situations is:

1)  Export the cross table  - format is not important.

2)  Add a new table in your analysis and use the exported data from step (1)

3)  Insert a new column in the imported table with the calculation [Result] = [Actual Period] - [Previous Period]

Hope this helps...

 Before exporting you should be able to add a new table from existing and pivot the same way you have built the cross table.

no pivoting or new tables needed 

in a crossTable  set the axes as:
Cell Values:  Avg(if([KPI]="Sales",[Actual Period],null)) as [KPI:Sales]
Horizontal: (Column Names)
Vertical: (None)