Hi, I’d like to create a Table (Pivot ?) where I can show by month, the actual revenue ($) and month over month increase (%). But I’d like to have both information to be in the same cell to avoid the multiplication of columns. Right now I managed to do it via a PivotTable but it contraints me to have 2 columns per months (1 for the revenue, and 1 for the MoM%). Is there any workaround ?
Hi @cecile3147 and welcome to the QuickSight community!
As long as you have a separate field already created for both the revenue and MoM increase percentage, you can build another calculated field using the concat function to combine them into one.
To do this, both fields will need to be strings though, so you may need to start by creating creating string fields for each using the toString function.
Let me know if you have any additional questions!
Hi @Brett , actually I tried this exact workaround but it didn’t work.with this concat formula:
concat(toString({revenue}),’ | ‘, toString({MoM}),’%')
I get an error message. “Mismatched aggregation. Custom aggregations can’t contain both aggregated and nonaggregated fields, in any combination.”
You will need to use the aggregation before casting to string.
Try something like :
concat(toString(sum({revenue})),’ | ‘, toString({MoM}),’%')
Here we are defining the relevant aggregation being used when pulled directly to pivot table. Assuming MoM has custom aggregation , no aggregation is defined for this field.
1 Like
Hi @cecile3147
It’s been a while since we last heard from you. If you have any further questions, please let us know how we can assist you.
If we don’t hear back within the next 3 business days, we’ll proceed with close/archive this topic.
Thank you!
Hi @cecile3147
Since we have not heard back from you, I’ll go ahead and close this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for relevant information.
Thank you!