Creation of Static dimension in pivot table

[sarfaraz_sheikh]

Dear All,

I want to create static dimension in qlikview.....I want to show the 0 values column in my pivot table ...However whenever i checked on suppress when value is null then 0 values column will also get hide.

Can anybody help me with this...i.e. how i can acheive this requirement...how i can add 0  for null column's in pivot table.

Please have look on below scenario for more clarity of problem....

When All Status_Description Selected:

Ergo_Loc                    TotalLeads_Considered      Follow_Up      Insurer_reject       Sales_closed_final  

Chennai      Amount                   197457                  11848                    -                        177247

                    count                        28                        2                        -                            25

Mumbai      Amount                   135475                   5439                      -                         104281

                    count                        20                         1                        -                            16

     -             Amount                   135475                   5439                     -                         104281

                    count                        20                         1                         -                            16

When I Click on Suppress When Value is null on Ergo_Loc Tab then It's look like below.

Ergo_Loc                               TotalLeads_Considered      Follow_Up           Sales_closed_final  

Chennai      Amount                   197457                           11848                      177247

                    count                        28                                 2                              25

Mumbai      Amount                   135475                           5439                         104281

                    count                        20                                 1                              16

My Actual Requirement is :

Ergo_Loc                  TotalLeads_Considered      Follow_Up        Insurer_reject       Sales_closed_final  

Chennai      Amount        197457                           11848                      0                        177247

                    count             28                                 2                          0                           25

Mumbai      Amount          135475                           5439                       0                         104281

                    count              20                                 1                          0                           16

Sarfaraz

[sarfaraz_sheikh]

Dear  gwassenaar‌ jagan‌ ......please answer i am very much stuck in this problem

[ToniKautto]

Duplicate of How to create static dimension in pivot table. I have locked this thread, please refer to the other thread.