Pivot table date

Question & Answer
, ,
1

image
image1268×364 41.3 KB

i want to create a table like this in quicksight

2

Hi @Siddhi_21,
Have you explored this article that further discusses pivot tables?

Let me know if you have any further questions!

3

hi @Brett
as u can check row contain both date and integer value …i want that .
image

i want the values into single row remove this blanks

4

Hi @Siddhi_21,
If you’re looking to combine the values from all columns down into one column, there is not an option in QuickSight that will provide that outcome. Data can only populate in a cell using the field that cell’s value is located in within the dataset.

In regards to a work around; you could potentially create a calculated field for each of your fields. It would need to be an ifelse statement that checks for a value in each of your columns and return the value if found. I’m not sure how you’d like to handle though if there are 2 values within a row (like your last 2 rows) as I’m not sure how you’d want to aggregate those.

Let me know if you have any additional questions.

5

Can u help me with ifelse statement

6

Hi @Siddhi_21,
It looks like you created a new post in the community so I’m going to close this one out so that there are not 2 open topics regarding the same case.

Thank you