Adding values to pivot table

[#1]

hi i am poppulating a pivot table like

count({<country={'India',USA,'Canada','UK'}>}country).My table contains India,USA,and Canada.But i want to show UK and corresponding number of users as 0.I have attached the screenshot of my pivot table.Is that possible

[stabben23]

If the dimensiontable with the country field missing UK then it will be hard. If You have UK in your dimension but you dont have any transaktion on UK yet then it is possible to show 0.

[alex_stone]

Hi, how to show 0 value for missing dimension value?

Currently, we have a pivot table, it will show all dimension value when all has value.

Some dimension value will hide after we select period time.

e.g.

Dimension 1 asset risk: High, Medium, Low

Dimension 2 client risk: High, Medium, Low

Table format:

Client Risk   High     Medium     Low

Asset Risk

High               3        6              4     

Medium          4        7              2

Low               5         8              7

/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

It will be shown as below after select period time

Client Risk      Medium     Low

Asset Risk

High               6              4     

Medium         7              2

Low               8              7

My problem is, how to show null value or missing value for Client Risk dimension. And want to show it as below after select period time.

Client Risk   High     Medium     Low

Asset Risk

High               0        6              4     

Medium          0        7              2

Low                0         8              7

Is there any approach to solve above problem?