TIBCO Spotfire

Hi, All.

Is it possible that 'Grand Total' column or row locate at first(under head) like below?

      City         |   Employee  |    Amount
 --------------------------------------------------------
  Grand total           750            210000  ----------- I want put the 'Grand Total' row at here!!!
      NY                 300             80000
      DC                 250             70000
      LA                 200             60000
---------------------------------------------------------

Best Regards.

Hi,

To do this you need to place the "Column Names" filter in the row level (Y Axis).

Then create a custom expression to show the totals first and aggregation second

Best Regards,

Eran

Hi, Eran.

Can you explain more detail, please?
I tried, but I can't.

I just want to put the 'Grand Total' at first row in the 'Cross Table'.
Is there an easy way?

Thank you.
Best Regards,

InTaeg.

Hi,

 I will try a simpler approach for doing this:

1. My data set:

City	Record type	Measure
NY	EmpCnt	300
NY	Salary	80000
DC	EmpCnt	250
DC	Salary	70000
LA	EmpCnt	200
LA	Salary	60000

1.1 If your data set is different in build you can make it look like this by duplicating the records and adding columns record type and measure

2. Add data source based on the first one => make it a pivot :

    Row Identifiers : Record Type

    Values            : Measure

2.1 If needed rename the new data source columns to match the old ones

3. Add a calculation to the new Data Source : "_Grand Total"  as [City]

3.1 The "_" is for later sorting

4. Add the new data source to the old one using : edit > add rows

Your first data source should look like this:

City	Record type	Measure
NY	EmpCnt	300
NY	Salary	80000
DC	EmpCnt	250
DC	Salary	70000
LA	EmpCnt	200
LA	Salary	60000
_Gran Total	EmpCnt	750
_Gran Total	Salary	210000

 

now create the pivot:

Using City for rows (Y.Axis) , Sum(Measure) for the values and Record Type for the Columns (X.Axis)

 

Best Regards,

Eran

 

Ah, I understand what you're saying. It's working, and helpful to me. But still not ideal.(when header condition changed, it's not worked.) According to support site, they added this to the enhancement request. Thank you, Eran. Best Regargs.