Viji
1
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 Quick Sight?
ErikG
2
Hi @Viji
you could try something with
And you have to
The values as well.
BR
Viji
3
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
4
Hi @Viji
Is “MaxPromoValue” already a calculated field.
BR
Viji
5
Yes, MaxPromoValue is already a calculated field.
Mismatched aggregation error is showing up because you are trying to concatenate a row level string value to table level aggregate.
Viji
7
Got it. But how to make it possible in Quick Sight? I want to replicate the following in Quick Sight (atleast which is in table):
Is it possible to have text in pivot table as mentioned above?
ErikG
8
Hi @Viji
what if using a pivot table and bring the {PPT Name} into the rows?
BR
