Need to display all rows/columns even if there's no data

[gopinathpc]

–Read and delete–
If your question is about data calculation/presentation, we encourage you to create a sample dashboard in Arena and include it with your question. This makes it easier for other users to try solving your problem and highly improves your chances of getting a solution quickly.
Read more about Arena here: QuickSight Arena -- An embedded instance of QuickSight within the QuickSight Community
(Copy / right click link in preview on a PC --or-- highlight / control / click link on a Mac and open in new tab.)
–

I am trying to create a dashboard that would displays all rows and columns even if the value (for example amount) is null/no value.

For example, if I have a column, say department and 3 rows, say location. I would like to display all departments, even if there’s no value for that department like:

                                 Department 1.                    Department 2.           Department 3

Location 1 10

Location 2 30

Locaton 3 20

[debapc]

Hi @gopinathpc - Not sure how is your dataset. I tried with 2 different datasets and got the following:

Dataset -1: Please refer to the screenshot below:

I created the following pivot table:

Please note that I ensured that the value field is a float or integer.

Dataset -2: Please refer to the screenshot below:

I created the following table:

Please note that I ensured that the department fields are a float or integer.

Let us know if this is helpful. Thanks!

[gopinathpc]

Hi,
Sorry the example values I mentioned got misaligned, instead of under each of the departments.

I meant to say

Location 1 has 10 under department 1
Locaiton 2 has 30 under department 1
Location 3 has 20 under department 1

department 1 has none.
But I want department 2 also to be displayed (without any values, of course).
department 1 department 2
Location 1 10
Location 2 30
Location 3 20

No values under department 2

[debapc]

Hi,

Can you please share a sample data set? Thanks!

[debapc]

Hi - If your dataset is as below:

following is the table visual: