Grand total based on blocks ..??
My req. is like, I have 3 blocks, each block I have sum and each block data has on different filters. Now I want put Grand total by summing of all blocks sum. I tried to create variable and putting all filter conditions (3 blocks conditions) in where clause. But it returns last block sum value only. Is there a way to achieve this grand total?
sorry. that solution for other post. But for this, I have created separate table with one row, created sum variables as per filters. it resolves my problem. Thanks to everyone here.