All values should be show

[subbareddykm]

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?

[subbareddykm]

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

[tyagishaila · Accepted solution]

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.