show all the columns in a table.

[rushi1093]

Please help as to how to keep all the fields on the table irrespective of any filters applied...for eg. if I have abc, pqr, xyz value in first column, and their corresponding sales and volume in column in 2 and 3 respectively. So I want to see all abc, pqr, xyz on left(1st columm) whether or not their sales and volume value is zero. 

[vinieme12]

The problem is where you are sourcing the dimension from

In such scenario  you should be sourcing dimensions from a separate dimension table which has all possible dimension values, like below.

facttable:
Load * Inline [
dimkey,dim2,measure
A,A,10
C,C,5
];

dimensiontable:
Load * Inline [
dimkey,dim
A,A
B,B
C,C
];
exit Script;

Now create a chart with dim from dimensiontable; sum(measure) and check Include Zero Values

Do not use key fields used to associate tables as dimensions in your chart

both tables have Include zero values checked, but as you can see dim sourced from a separate dimensiontable will show 0 when there is no associated data 

Output

[vinieme12]

@rushi1093 kindly close the thread by marking a response as solution if your problem is resolved