using pivot mode with server side calculations

[youngvan]

Greetings,

i like pivot a lot. The problem is:
- we working with a huge data (1TB+)
- totals like distinct/unique or some other complicated functions can be calculated only from raw data

is is possible that pivot doesn't calculate everything by himself but send query to server passing all selected params and then get and display all needed data from server (including totals)

thanks

[paramvir]

It can be displayed as treegrid in combination with grouped columns.