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
No comments:
Post a Comment