How to show string in pivot table cell?

Q&A
, , ,
1

Hi, I am trying to use pivot table to show my data. For example:

my data in dataset like:

image
image1156×448 37.5 KB

I want result like:

image
image676×278 6.38 KB

So I created last_value calculation field using lastValue function:

lastValue(value, [{value} ASC], [{field_name}, {value}])

But I got result like:

image
image1046×577 60 KB

Is it possible that I can merge f2, f3 in 1 line? Or is there any other function I could use?

Here is the test dataset I am using

select
'id1' as id,
'f1' as field_name,
'100' as value,
'user1' as completed_by,
'2025-01-01' as completed_at
union all
select
'id1' as id,
'f2' as field_name,
'200' as value,
'user1' as completed_by,
'2025-01-01' as completed_at
union all
select
'id1' as id,
'f3' as field_name,
'300' as value,
'user1' as completed_by,
'2025-01-01' as completed_at
union all
select
'id2' as id,
'f1' as field_name,
'100' as value,
'user2' as completed_by,
'2025-01-02' as completed_at
union all
select
'id2' as id,
'f2' as field_name,
'aaa' as value,
'user2' as completed_by,
'2025-01-02' as completed_at
union all
select
'id2' as id,
'f3' as field_name,
'aaa' as value,
'user2' as completed_by,
'2025-01-02' as completed_at
union all
select
'id2' as id,
'f4' as field_name,
'aaa' as value,
'user2' as completed_by,
'2025-01-02' as completed_at

Thanks

Ce Wu

2

Hello @cewu

Greetings from Quick Suite Community!

I found one workaround which you can try:
a) First, you can collapse all the rows so that you get one line for Field_name
b) Then from Format Visual options → Pivot options → you can try hide the button and hide single metric

It should work then!

I am attaching screenshots for reference.

1
12710×1206 278 KB

2
22710×1206 264 KB

Hope this helps!

3

Hi @cewu ,

Just checking back in since we haven’t heard from you in a bit. I wanted to see if the guidance shared earlier helped resolve your question, or if you found a solution in the meantime.

If you still have any additional questions related to your initial post, feel free to share them. Otherwise, any update you’re able to provide within the next 3 business days would be helpful for the community.

Thank you

4

Hi @cewu,

Since I haven’t received any further updates from you, I’ll treat this inquiry as complete for now. If you have any additional questions, feel free to create a new post in the community and link this discussion for context.

Thank you