SaasMatter

Transformations

Grid Transformation

User can set transformation of grid and totals of grid in Transform tab.



< MAINGRID > is starting tag and < /MainGrid> is ending tag.

SCROSS -> Type of transformation.

TARGET -> we can set index of defined complex views in view in this tag if complex view is not define then we can set 0 for this tag.

IDFIELD->Assigned key field. Like Returnperiod

PIVOT->Assigned field to transform as header. Like SectionName

AGGCOL->Assigned field to transform below header respective SectionName. Like Amount

Output



Chart Transformation



Output :



Grid Totals



< TOTGRID > is starting tag and < TOTGRID> is ending tag.

TOTAL TITLE -> User can set title for display.

FIELD KEY -> User can set column for make total.



Output :