Hi Guys,
Below is a simple use of singleton in congos .It allows you to do summary calculation and its the only thing that you can add in a list crosstab that is coming from separate query .
Notice that even after filtering the overall calculation remains unaffected by filter .This has been done making use of singleton .
Steps
1) Create a summary total
2) Unlock the cell
3) delete total
4)Insert singleton
5)In the singleton query define total( Quantity) and put it there
Below is a simple use of singleton in congos .It allows you to do summary calculation and its the only thing that you can add in a list crosstab that is coming from separate query .
Notice that even after filtering the overall calculation remains unaffected by filter .This has been done making use of singleton .
Steps
1) Create a summary total
2) Unlock the cell
3) delete total
4)Insert singleton
5)In the singleton query define total( Quantity) and put it there
Crosstab space
Crosstab space with fact cells
