Consider below small Inline Table... Load it in your QVW script...
Load * Inline
[
ID, Month, Sales
A, Jan, 100
A, Feb, 150
A, Mar, 250
C, Jan, 50
C, Feb, 100
C, Mar, 150
D, Jan, 25
D, Feb, 50
D, Mar, 125
];
Now create a Straight Table
Dimension
ID
Month
Expression
1) SUM(Sales)
This will give you Total Sales per ID per Month
2) SUM(TOTAL Sales)
This will give you Total Sales for all ID and Month (this will be changed based on selection)
Create a List Box for Month and ID and try to select any value from them... This will give you changed result..
3) SUM(ALL Sales)
Same result as above while not selected anything.. But even though if you select any value from ID or Month, the result will be the same.
4) SUM(TOTAL <Month> Sales)
Total Sales by Month
5) SUM(TOTAL <ID> Sales)
Total Sales by ID
6) RangeSum(Above(TOTAL SUM(Sales),0,RowNo()))
This will add the TOTAL Sales for each ID from 1st to last row
Hope this will help...
