Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have below data
Sample:
LOAD * INLINE [
Group, Serial Name, Month, Value
A, Serial 1, 1, 263
A, Serial 2, 2, 269
A, Serial 3, 3, 275
A, Serial 4, 1, 281
A, Serial 5, 2, 287
A, Serial 6, 3, 293
B, Serial 7, 1, 299
B, Serial 8, 2, 305
B, Serial 9, 3, 311
B, Serial 10, 1, 317
C, Serial 11, 2, 323
C, Serial 12, 3, 329
C, Serial 13, 1, 335
C, Serial 14, 2, 341
C, Serial 15, 3, 347
C, Serial 16, 1, 353
C, Serial 17, 2, 359
C, Serial 18, 3, 365
];
I have a straight table, in that Group and serail name is my dimention and expression is Sum(Value).
My requirement is if i select any month it is giving respective groups and serial names its fine . But my user wants if he select any month available group and serial name 's value should be show and remaing we have to show as 0.
Can any one tell me how to achieve it?
Fiind attached qvw,Hope it will help you.
Add 1 more colum in expression tab, and by pass all dimensions
Sum({<Group=,Month=, [Serial Name]= >}1)
now go to presentation tab & hide this column.
Sample Output for Month =1 is
Group | Serial Name | SUm(Value) |
A | Serial 1 | 263 |
A | Serial 4 | 281 |
B | Serial 7 | 299 |
B | Serial 10 | 317 |
C | Serial 13 | 335 |
C | Serial 16 | 353 |
A | Serial 2 | 0 |
A | Serial 5 | 0 |
B | Serial 8 | 0 |
C | Serial 11 | 0 |
C | Serial 14 | 0 |
C | Serial 17 | 0 |
A | Serial 3 | 0 |
A | Serial 6 | 0 |
B | Serial 9 | 0 |
C | Serial 12 | 0 |
C | Serial 15 | 0 |
C | Serial 18 | 0 |
Fiind attached qvw,Hope it will help you.
Add 1 more colum in expression tab, and by pass all dimensions
Sum({<Group=,Month=, [Serial Name]= >}1)
now go to presentation tab & hide this column.