Text in a pivot table

[Viji]

I wanted to add text in a pivot table as follows:

In my case, I want as follows:
{PPT Name} “: Up to” {MaxPromoValue} “off IR (”{MaxPromo%}“)”

PPT Name:- Dimension
MaxPromoValue and MaxPromo%:- Calculated fields

How to do it in QuickSight?

[ErikG]

Hi @Viji
you could try something with

Concat - Amazon QuickSight

And you have to

toString - Amazon QuickSight

The values as well.
BR

[Viji]

While attempting to do the following, I got mismatched aggregation error:

concat({PPT Name},‘: Up to $’,toString({MaxPromoValue}))

May I know what’s wrong in this?

[ErikG]

Hi @Viji
Is “MaxPromoValue” already a calculated field.
BR

[Viji]

Yes, MaxPromoValue is already a calculated field.

[Aneek_Arora]

Mismatched aggregation error is showing up because you are trying to concatenate a row level string value to table level aggregate.

[Viji]

Got it. But how to make it possible in QuickSight? I want to replicate the following in QuickSight (atleast which is in table):

Is it possible to have text in pivot table as mentioned above?

[ErikG]

Hi @Viji
what if using a pivot table and bring the {PPT Name} into the rows?
BR